MySQL sudden throughput increase

Question

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!

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

score 1 · Accepted Answer · answered Dec 21 '10 at 13:04

1

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

answered Dec 21 '10 at 13:04

em2345

11
4

score 0 · Answer 2 · answered Dec 15 '10 at 19:25

0

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.

answered Dec 15 '10 at 19:25

Mike

181
3

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

MySQL sudden throughput increase

2 Answers2