He was far too low on table_open_cache which was in turn bumping into the LimitNOFILE limit. On Thu, 28 Jul 2022, 22:57 , <ngtech1ltd@gmail.com> wrote:
I tried to follow but missed the solution. What OS limit are you talking about?
Thanks, Eliezer
---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: ngtech1ltd@gmail.com Web: https://ngtech.co.il/ My-Tube: https://tube.ngtech.co.il/
-----Original Message----- From: Maria-discuss <maria-discuss-bounces+ngtech1ltd= gmail.com@lists.launchpad.net> On Behalf Of Cédric Counotte Sent: Thursday, 28 July 2022 21:07 To: Gordan Bobic <gordan.bobic@gmail.com> Cc: Mailing-List mariadb <maria-discuss@lists.launchpad.net>; Pierre LAFON <pierre.lafon@1check.com> Subject: Re: [Maria-discuss] MariaDB server horribly slow on start
I had to restart a server earlier and with this new setting, everything was smooth after the SST ! for the second time in a row.
I just started another server, and it did its SST and worked just fine immediately! Wow! I never imagined such an OS limit would be imposed and cause so much trouble! It ought to be documented if not already (then I missed it).
Thanks a ton for your help! That's a big problem solved!
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp