I have been running the same installation of James and MySQL on the same
system for several years. In the last 6 months I've been encountering a
problem. Every few days the MySQL CPU utilization goes up
dramatically. I found that if I optimize the SPOOL table in the James
mail db, the CPU goes to near 0... for a while. A day or so later, CPU
has gone back up.
I completely understand the nature of SPOOL table. It probably has
100,000 records added and removed every day with all the spam, etc my
server processes. I know this causes the db to expand, and optimizing
cleans it back up. I guess I could write a cron job to go out everyday
and run an optimize. But I'm curious if I have the right table type. I
don't really know much about MyISAM vs. InnoDB. SPOOL is currently
MyISAM. Would changing it make it run more efficiently given the huge
activity pace of this table? Is there something else I might be doing
wrong?
Thx.
Jerry
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
