How to manually build mysql cache

Posted by hamstar on Stack Overflow See other posts from Stack Overflow or by hamstar
Published on 2010-06-09T21:37:13Z Indexed on 2010/06/09 21:42 UTC
Read the original article Hit count: 198

Filed under:
|
|

I have a table of over 150,000 rows of which most would be updated daily. I have mysql caching turned on so the pages load faster however everytime the database is updated the pages load slow again, which I assume is the cache building itself again.

So at the moment I have resorted to doing a wget -m --delete-after http://localhost/ on the server however this takes about 4 hours to complete and moves something like 13 gig.

Is there a better way to do this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about caching