Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

Hi Mike, I will use MDEV-13869 MariaDB slow start for tracking this fix. The fix is not as trivial as I thought; I got some of my corruption-injection tests failing. Furthermore, I think that in MariaDB 10.2+, we could remove the extended checks also wh

Re: [Maria-discuss] Parallel Databases and network security

Longing for peace ...the day I land a women as wonderful as you that would be the day. The sun might shine again, and the clouds roll back the ocean will calm, and the fish will be plentiful one will be able to look over the ridge and see the ocean in the haze. Seagulls will float gently int

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

Marko, Thank you again for such a clear explanation of your reasoning! Should you be able to pass along a defect ID that I can follow, I'll follow that and wait for the next release to test things out. Best, Mike On 2018-01-16 01:48 PM, Marko Mäkelä wrote: Hi Mike, Sorry, I was busy with

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

Hi Mike, Sorry, I was busy with other development tasks. In the error log that you attached, the first startup upgrades the redo log from the pre-MySQL 5.7.9/MariaDB 10.2.2 format: > 2018-01-08 5:39:50 140390495905984 [Note] InnoDB: Upgrading redo log: > 2*536870912 bytes; LSN=1395657325222 > 2

Re: [Maria-discuss] Parallel Databases and network security

Am 16.01.2018 um 17:08 schrieb Ruben Safir: https://www.howtogeek.com/howto/mysql/switch-mysql-to-listen-on-tcp/ Actually, i came up with this early on, but I as hoping for someone to point out the parallel docs in maria bind-address is a basic option https://mariadb.com/kb/en/library/confi

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

Hi Marko, For what it is worth (and I am unsure if I understand the issue you described), I ran mysqlcheck --extended on all database tables.  It ran clean. Why do you think my database is in a crashed state and therefore needing recovery? Thanks, Mike On 2018-01-16 10:44 AM, Michael

Re: [Maria-discuss] Parallel Databases and network security

> > https://www.howtogeek.com/howto/mysql/switch-mysql-to-listen-on-tcp/ > Actually, i came up with this early on, but I as hoping for someone to point out the parallel docs in maria https://www.cyberciti.biz/faq/unix-linux-mysqld-server-bind-to-more-than-one-ip-address/ This is old and mysql..

Re: [Maria-discuss] Parallel Databases and network security

BTW - we are not getting dragged into a systemd fight either.. sorry. On Tue, Jan 16, 2018 at 10:45:09AM -0500, Ruben Safir wrote: > On Tue, Jan 16, 2018 at 09:33:18AM +0100, Reindl Harald wrote: > > > > Am 16.01.2018 um 09:16 schrieb Federico Razzoli: > > >Can we keep this list usable for tho

Re: [Maria-discuss] Parallel Databases and network security

On Tue, Jan 16, 2018 at 09:33:18AM +0100, Reindl Harald wrote: > > Am 16.01.2018 um 09:16 schrieb Federico Razzoli: > >Can we keep this list usable for those who use it for a technical purpose? > > surely if guys which attack people with knowledge respect > recommendations of expierienced sysadmi

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

Hi Marko, I've been reading more into --innodb-force-recovery and trying to understand the state of my new slaves. If I understand what you are saying, the current databases are in an unrecovered state and requires crash recovery.  If that is the case, should my log file indicate this the ca

Re: [Maria-discuss] Parallel Databases and network security

Am 16.01.2018 um 09:16 schrieb Federico Razzoli: Can we keep this list usable for those who use it for a technical purpose? surely if guys which attack people with knowledge respect recommendations of expierienced sysadmins instead bitching around while asking noob questions or shut up at al

Re: [Maria-discuss] Parallel Databases and network security

Can we keep this list usable for those who use it for a technical purpose? Federico Da: Reindl Harald A: maria-discuss@lists.launchpad.net Inviato: Martedì 16 Gennaio 2018 5:31 Oggetto: Re: [Maria-discuss] Parallel Databases and network security Am 16.01.2018 um 05:10 schrieb Jan