MySQL slow, but speed up after drop disk caches
I have very busy Linux MySQL server with huge database. Server usually work on load average 2 or less. The server have software raid (mdadm) that is currently rebuilding. Several times today, MySQL get slower and load average reach 200-300-500. In same time iostat is not big – 20-30% maximum. Swap is currently turned off, … Read more