up vote 0 down vote favorite
share [g+] share [fb]

What could be the cause of a sudden increase in MySQL throughput (from an average of 1.5M/s to 7.5M/s). The system is running WordPress on a trafficked site (2M monthly pageviews). The throughput is monitored with munin. Is there a way to see in MySQL how much data a query transfers? Thank you!

link|improve this question
Wordpress/Webserver caching functionality being temporarily disabled could be a cause. – weeheavy Dec 15 '10 at 15:55
caching is enabled and seems to be working fine. In munin, the number of queries does not seem to have spiked with the throughput, it looks normal. – em2345 Dec 15 '10 at 16:00
feedback

2 Answers

up vote 1 down vote accepted

Fixed in the end. The source was trivial - a code change causing giant result sets.

link|improve this answer
feedback
up vote 0 down vote

Are you on a VM, Slice, or other hosted environment? If so, your host may have moved you to new hardware, or, more likely, other slices on your hardware may have been moved off or closed.

link|improve this answer
We are using a dedicated server, so this was not the cause. – em2345 Dec 21 '10 at 13:02
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.