maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06279
Re: MariaDB server horribly slow on start
-
To:
Gordan Bobic <gordan.bobic@xxxxxxxxx>
-
From:
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
-
Date:
Wed, 27 Jul 2022 12:12:10 +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=QfUy0V1DO19GUiFW21ss0Run4sh04PIcJhcQIVCy9mA=; b=g2tCVj5FBXUiQ3wQKTjAyF9G7vHZOZ4G0kbyJFiZt++6L3YzbqHude3GVo2+XbKK8Vbgeoob8qEoPFd/k3TUztt6VH/nSRtmWYZbfy+4xqJIoB2FyWd8euZuBn/Kpzu4+fYo7uE4XWNKs+5SmCH9idwCwrvChM4LMlaOnoCTsxzj7Rk2vv7UTYi1GgF2d8dNpZuK3Q3/D/dpwJu5986QL/6yXyJOvESFtCvkEAL6N9dxnXg8bz3j9SHyRAfY+Bob9LK2n8ryjin4NxMNc2zjBWSu2PLZ/er+p+yYwsa3yrRqCjjkZl2Gq5PvqVezwxd5WTYM62SNkhAJFKoagng5fw==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Ge/Tjo/xYkTbIg1ZZZhDq/E0EnPiwEXT437GAnUtXg3VjvK45PmS55WQS9ROoWzXuDPDp0Yusr1a+qnRbtJAQpDZL0JWwJcdyLRdmBhlUfGBa988uu4HyQs/QslWOxSpgDyHaCkj2cQ/faB4chVTmjFlawNqWOyAt7UnVMiBNhiD4KdzRnoJKK9azq+sbyK/H3hhFERgFT2uaEXyQoQqUlOc0GM1AZCTWAF5gRJ0ajeDIqHuI/W9KicqaS7dry3Ou9ZrojxpSP+nplzXANASafiA4vBny4qm2x+txrMEcfTKFVJT7Bjs+Br/IjXs6pKU1OFW9Lv1/HUpCIKMod/3qg==
-
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>
-
In-reply-to:
<CAMx4oe0VdQTy-ia6KsHO9L_3Dh6VqvXQh7gWMQvnO+N=mPenjQ@mail.gmail.com>
-
Thread-index:
Adihm/U8OcwjLBOASdqVrFuHw0ZWfgAA2yMAAAGY8HAAAKBwgAAACDYQAADYM4AAAFTbwAAAgIiAAACe0LA=
-
Thread-topic:
[Maria-discuss] MariaDB server horribly slow on start
AH! Thanks for the input about PMM, I'm actually using netdata as you can see on screenshot.
And yes, it's better to have one than nothing, it helped me numerous times spot improvements and limits that could be changed to improve things.
I did an upgrade from 10.4 -> 10.5 -> 10.6 while it kept saying SST are not supported, but it worked 😉 Not sure I'm glad it worked now that I might have to revert back to 10.4 (and Ubuntu 20.04!).
-----Message d'origine-----
De : Gordan Bobic <gordan.bobic@xxxxxxxxx>
Envoyé : mercredi 27 juillet 2022 13:51
À : Cédric Counotte <cedric.counotte@xxxxxxxxxx>
Cc : William Edwards <wedwards@xxxxxxxxxxxxxx>; Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Maria-discuss] MariaDB server horribly slow on start
On Wed, Jul 27, 2022 at 2:38 PM Cédric Counotte <cedric.counotte@xxxxxxxxxx<mailto:cedric.counotte@xxxxxxxxxx>> wrote:
>
> No idea what is PMM ?
https://www.percona.com/software/database-tools/percona-monitoring-and-management
I prefer v1, but in Percona's build of PMM v1 there are several bugs / missing features that are going to cause you problems with newer kernels and MariaDB 10.5+.
I have patches to fix it, but my build of it is not yet publicly available. But v2 is still far better than no PMM.
> Do you have a bug tracking this behavior, so that maybe I can follow it or apply work-around ?
I cannot say I have looked. I'm generally happy to leave testing to others until I have an overwhelming reason to upgrade to a version with a lot of changes. And 10.5 was a rather big feature release.
> I’m not quite keen on downgrading (which I’ll do using the spare servers I have and a little replication in between), but if it turns out to provide a more reliable alternative I’m eager to do it then!
Replication from newer version to older version is also not officially supported. It usually works, though.
Attachment:
netdata.png
Description: netdata.png
Follow ups
References
