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
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