nuke_amazon_cache is crashing my server

[icarbohydrate]

I have been running nukeamazon for over a year now with no problems. about 3 weeks ago my server started freezing. The problem turned out to be with the nuke_amazon_cache. for some reason it will get really big create 100 mysqld threads, and at some points use 100% of my processor. it seems to have something to do with a mysql command that involves selecting the unix time stamp. when I manually kill this connection I am able to take back control of my server for a short time. Once I empty the nuke_amazon_cache and repair the database it goes back to normal for a while. the problem may have started about the same time I upgraded to os x 10.4.4. Any ideas?

[icarbohydrate]

any ideas? it seems that it is not deleting the cache after 2 hours as it is supposed to.

[icarbohydrate]

are you having this problem also? your pages are painfully slow to load. you home page said: Page Generation: 25 Seconds - Yikes

the command to clear your cache for phpmyadmin is:


DROP TABLE IF EXISTS nuke_amazon_cache;
CREATE TABLE nuke_amazon_cache (
cid int(11) NOT NULL auto_increment,
time datetime NOT NULL default '0000-00-00 00:00:00',
url varchar(60) NOT NULL default '',
xml longtext NOT NULL,
PRIMARY KEY (cid),
KEY cid (cid),
KEY date_time (time)
) TYPE=MyISAM;

[EJDiaz]

This is a better solution.
_________________
~Edgardo
PrecioGasolina.com | E.J. Stores

[icarbohydrate]

I also run that script, but that will not work unless I first clear the cache.. do you know why the cache is getting so big?