maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06283
Re: MariaDB server horribly slow on start
-
To:
Gordan Bobic <gordan.bobic@xxxxxxxxx>, Marko Mäkelä <marko.makela@xxxxxxxxxxx>
-
From:
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
-
Date:
Wed, 27 Jul 2022 12:36:15 +0000
-
Accept-language:
en-US, fr-FR
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=1check.com; dmarc=pass action=none header.from=1check.com; dkim=pass header.d=1check.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=FScMsWpO/w9L2wm2401bpqbksibPjZ30Ks8pgRwKMYU=; b=h17OtnGpMCGPceyiVnIIhfXp5Cphz06EZPbM2kyIrV6QaMJjk2qE92CfdQnBaj6sGN07put8yw7VQAq3vTXM65JP9LyzXIhgUieBmbGVQ4c2G9a+pgiybFD/DwNvnUrKkF7jK88OPGhiknsHx7evWF75hP61TYvUvINrzNy1JFVF/O03lnwn/Ir9mYyakZbl/WXuSXZNFX3SW+y/Knvushy4JuLHaD4/St4pj8ic2Omr3Gxs81DnuDGC5B7sa5MKrYFcJyq7HQRA2JC4m1R2Fk8+8XpGLZs7rpSJ73JExH9g83/v3RaHpkcjJmo2ImVzr/jjckR9CaY/3dxfUOs9HQ==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=LqrpWfR+0uLGN2TM9T3P7n/AThGXz9sopYmU01I79ZcCaxpn/GgvVGe3/nrcGzD9BTdX+5f+fuN7D90qSE0QqrYoXRWej2kcxK4yd8AsMHZ+8XUvL+owwaKUX/jIRWLSs44uTopMlSYLtfiHQkTlpTIcAdprtyfFUKSSzp3jCuYcBd9CbbtpMXrW1FnR/Hc7w4mhqjU+BD/mPp1je/U1TSfRgz33PKRL6H3Aa4inT4Z/BAeNWMFCUV0oAjbmd2XJwaDOK4D/sPgONqwmg8QMxDSBCPMlzp6R6Ya/j0Gxs+nKytgATjvdQaIbNMx68tjoQtYhse7UbaH2+Zn4M5YFlw==
-
Authentication-results:
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=1check.com;
-
Cc:
Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>, Pierre LAFON <pierre.lafon@xxxxxxxxxx>
-
In-reply-to:
<CAMx4oe1dJC7_3f9uSbwTzfwnPY974+ki=mwzBD-U7AtVd4vhPA@mail.gmail.com>
-
Thread-index:
Adihm/U8OcwjLBOASdqVrFuHw0ZWfgAA2yMAAAGY8HAAAKBwgAAACDYQAADYM4AAAW/DgAAAviOAAAAlMaA=
-
Thread-topic:
[Maria-discuss] MariaDB server horribly slow on start
Reading this: https://jira.mariadb.org/browse/MDEV-27295
It's quite unclear when it is fixed or reverted.
That said I read that the following setting might fix it:
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.001;
Is that correct and should I try that and see if that helps?
-----Message d'origine-----
De : Gordan Bobic <gordan.bobic@xxxxxxxxx>
Envoyé : mercredi 27 juillet 2022 14:29
À : Marko Mäkelä <marko.makela@xxxxxxxxxxx>
Cc : Cédric Counotte <cedric.counotte@xxxxxxxxxx>; Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Maria-discuss] MariaDB server horribly slow on start
On Wed, Jul 27, 2022 at 3:08 PM Marko Mäkelä <marko.makela@xxxxxxxxxxx> wrote:
>
> On Wed, Jul 27, 2022 at 2:48 PM Gordan Bobic <gordan.bobic@xxxxxxxxx> wrote:
> >
> > There is no supported downgrade path other than logical dump+restore.
> > There are also no packages built for distros where the major version is older than what ships with the distro.
> >
> > Since your queries seem to end up stuck in commit stage, it could be related to redo log flushing, which behaves very erratically on 10.5+. If it leaves the log to fill up to 90% and the state transfer hits, it could be that with the checkpoint age already high, there just isn't enough headroom to avoid a massive stall. Purely guessing here without any telemetry.
>
> I think that you may refer to InnoDB page flushing. There was some
> misunderstanding around that, and indeed some partly unintended or
> uninformed changes in behaviour (in 10.5.7 and 10.5.8) that were
> reverted later. It could be useful to read
> https://jira.mariadb.org/browse/MDEV-27295.
What version was it reverted in?
I am still seeing the errant redo log flushing behaviour in 10.5.15.
It looks like no flushing happens until the hwm is reached at about 85% full. It then tries to commit everything down to the lwm. And inbetween it doesn't do anything, even while everything is idle and it should be running down the
Follow ups
References
