Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|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
add comment

2 Answers

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.

share|improve this answer
    
We are using a dedicated server, so this was not the cause. –  em2345 Dec 21 '10 at 13:02
add comment
up vote 1 down vote accepted

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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