April 08, 2005
MySQL Madness
My cache seems to require optimization and flushing all the time, or the database locks up. Is there an SQL query that will automatically optimize and truncate the cache table on a regular/periodic basis?
MySQL version is 4.0.22-standard.
-
http://www.google.com/search?q=mysql+cache+flushing&btnI=I'm+Feeling+Lucky http://www.google.com/search?q=crontab+tutorial&btnI=I'm+Feeling+Lucky
-
unfortunately, the info at those links is a bit too technical for me to understand. I'm not so much a newbie... just retarded. I guess what I'm really looking for is a script that I can use webcron.org to execute.
-
Well, I don't come bearing any scripts but with the advice that crontab isn't all that tough. Using the information from Fuyugare's links you can easily put together the necessary script to run a cache flush. Linux Gazette has a nice article on it here as does Micro-Gravity.