Main > Forum/Website Discussion
*** SERVER ISSUES *** - we are currently experiencing a heavy load on the server
shock_:
Make sense of your MySQL slow query log file by installing percona toolkit and running pt-query-digest on the mysql-slow.log. pt-query-digest takes --since= and --until= so you can limit it to slow queries that occurred at an interval you care about, e.g. midnight to 1am. If a part of the problem is indeed iowait (which stands to reason if other services are slow during the worst of it, your CPU load is probably enormous) it's presumably going to either be a lot of table writes or perhaps large temp tables on disk due to subqueries. pt-query-digest will show you that plain enough.
Le Chuck:
I bet if we could like threads and had +fu this wouldn't have happened.
pbj:
Have you tried turning it off and back on?
Slippyblade:
--- Quote from: pbj on May 12, 2016, 12:40:27 pm ---Have you tried turning it off and back on?
--- End quote ---
For great justice! Seriously though... have you?
lilshawn:
--- Quote from: Slippyblade on May 12, 2016, 01:14:32 pm ---
--- Quote from: pbj on May 12, 2016, 12:40:27 pm ---Have you tried turning it off and back on?
--- End quote ---
For great justice! Seriously though... have you?
--- End quote ---
have you tried forcing an unexpected reboot?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version