MySQL can take more than an hour to start
3
votes
4
answers
1771
views
I have a mysql (Percona) 5.7 instance with over 1Million tables. When I start the database, it can take more than an hour to start. Errorlog doesn't show anything, but when I trace mysqld_safe, I found out that MySQL is getting a stat on every file in the DB.
Any idea why this may happen? Also, please no suggestion to fix my schema, this is a blackbox. Also keep in mind that I've heard it all regarding how bad the design is....
Thanks
Asked by Younes
(171 rep)
Feb 20, 2017, 04:28 PM
Last activity: Dec 13, 2024, 06:02 PM
Last activity: Dec 13, 2024, 06:02 PM