maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06269
Re: MariaDB server horribly slow on start
-
To:
William Edwards <wedwards@xxxxxxxxxxxxxx>
-
From:
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
-
Date:
Wed, 27 Jul 2022 10:45:04 +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=7h9nLIPRwq8NdksNCQwPc5PLOUAeG4E3u2iBOz90bWU=; b=bEw6u4V0+7T9bspSG4nM6ql6/HEkMwcjSpRp5QiPlbqb8JJzj9rdWpi0n59VcW3XQp0um8QxepFw9jsFmP7LtI453gy20pBdHEnKrLRe6KmeScO9a+/mt2xoMtWXnH55eUunwhF7MzkL87ncGxJpybKI2bN2jM2YTw8uMzNWPicIAOmKTknvJZbZ2N8cZC1UOACfmRz3oCd3QNiLo8YGsdFVOE+drlqX58KjDnmVgvQeEjcOldaxW5s4iGBf2d4qNRYzmsUYu494Bav0DMV4BmhAsqSsRU4UmvVq7Nf7foTsK8OQy8iAjB1Ut3WMuZ9EzMRiEx/MsoS20FecNDMx1g==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=So18BxXF/Gx0o1K99G4ktRlV7aTYdMeWfqlY9b8oAuVcMG83/ZoZKwWrG/pruS6aWPf3G/dNb5M250mSo2zk5bdnVZNoKMk50ftTdb1QXCc4NBDynPTbOORXUxe9GTfY1vhkEhNO972y3gnIX4zLZOr4fUOcXtgNxbRNN+JOgK9dygAvlEBxPmuoZAwZy2KvgCx+5+OrLy2agdO7erCpLRlcfW5Z09l1YkYRmsNxv/6XYHDJ3dnWCzUajimVxnrja2RkZhRiadFQF1ulLETQ78e0KvJTIfy95sFBvb42NTibZ69pNj9UEZPZnt1vUDRv3+cZsxUJ0xVlL5EAIeIgSA==
-
Authentication-results:
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=1check.com;
-
Cc:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
In-reply-to:
<604583AA-7742-4A2E-B67F-84FEE6751E12@cyberfusion.nl>
-
Thread-index:
Adihm/U8OcwjLBOASdqVrFuHw0ZWfgAA2yMAAAGY8HA=
-
Thread-topic:
[Maria-discuss] MariaDB server horribly slow on start
I must add that the slowness occurs when the SST or IST are completed, and the server becomes available. Donor is also entirely blocked (it seems) when the queue is being processed.
While the SST is performed, there is no issue.
De : William Edwards <wedwards@xxxxxxxxxxxxxx>
Envoyé : mercredi 27 juillet 2022 11:58
À : Cédric Counotte <cedric.counotte@xxxxxxxxxx>
Cc : maria-discuss@xxxxxxxxxxxxxxxxxxx
Objet : Re: [Maria-discuss] MariaDB server horribly slow on start
Op 27 jul. 2022 om 11:46 heeft Cédric Counotte <cedric.counotte@xxxxxxxxxx<mailto:cedric.counotte@xxxxxxxxxx>> het volgende geschreven:
Hello all. I hope I’m at the right place to ask this question.
I opened a bug here: https://jira.mariadb.org/browse/MDEV-28969, however I was told to use this mailing list.
We have 4 MariaDB servers in a Galera Cluster and it happens that a server has to be restarted (be it for a crash which I have to open a bug for) or maintenance.
When that happens, the restarted server is causing huge slow down on the whole cluster, and it lasts for 10 to 30 minutes at the very least!
And by huge, I mean huge, we end up with 500 to 800 pending queries on all servers as you can see on attached screenshots
I’ve attached the configuration of any server for reference in case this is the source of the issue.
Any way to solve this would be greatly appreciated.
You seem to be focusing on effect. What is the cause? SST?
Regards,
3C.
[cid:image001.png@01D8A1B6.B1B72800]
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
Follow ups
References
