Why would restarting MySQL make my site faster?

Posted by beagleguy on Stack Overflow See other posts from Stack Overflow or by beagleguy
Published on 2010-04-15T18:20:25Z Indexed on 2010/04/15 18:23 UTC
Read the original article Hit count: 198

Filed under:
|

hey all, my site started dragging lately, the queries taking exceptionally longer than I would expect with properly tuned indexes. I just restarted the mysql server after 31 days uptime and every query is now substantially faster and the whole site renders 3-4 times faster.

Would there be anything that jumps out at you as to why this may have been? Improper settings on my.cnf perhaps? Any ideas as to what I can start looking at to try and pinpoint why?

thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Performance