Skip to main content

Timeline for MySQL became slow overnight

Current License: CC BY-SA 4.0

5 events
when toggle format what by license comment
May 9 at 6:30 comment added Markus W Mahlberg @Matt That does not imply that this is handled efficiently. You may also want to check your ulimits specifically your max open files.
May 7 at 1:00 comment added Matt table_open_cache is currently set to 5000. I have 4017 tables.
May 7 at 0:54 comment added Matt I added a SHOW GLOBAL STATUS dump to my question. I am reading through your links now.
May 7 at 0:40 comment added Matt Thank you for your answer.
May 6 at 20:07 history answered Rick James CC BY-SA 4.0