Re: mysql goes 100% after james started

[Jerome Lacoste @ BBC]

Noel J. Bergman wrote:

As a side note I found out that in mysql 'select recipients from
james.spool' take a long time (more than 30 seconds), even though
there are only 2-3 messages in the spool.

I've seen that before, very occasionally, from the mysql client interface.
Restarting mysql fixed it.  Right now you must start james after mysql (and
restart it if you restart mysql).

You might want to run isamchk against that tables.

Running myisamchk on the MYI files took a long time on the james.spool table. There was plenty of deleted blocks,
Checking MyISAM file: james/spool.MYI
Data records: 0 Deleted blocks: 40071

/opt/mysql/bin/myisamchk -r james/*.MYI solved the performance problem.

Thanks! don't have to upgrade mysql for now!



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]