mysqld is at 99%

[rmvg]

Hello all i have been running version 6.0.0.1 now for about a month everything was going ok until yesterday. For some reason each time i try to access my mail though the web i get an error about the server taking to long to respond.

Quick check of top is telling me that mysqld owned by zimbra is at 99% it goes away for a bit, but as soon i check my email again i shoot back up to 99% and stays there for way to long making the web interface unresponsive.

I do not seem to see anything that corresponds in the zimbra.log or the mysql_error.log but have posted a tail of the latter anyhow

091001 22:43:24 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

091001 22:43:24 mysqld ended

091001 22:48:14 mysqld started
091001 22:48:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091001 22:48:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091001 22:48:16 InnoDB: Started; log sequence number 0 1884987325
091001 22:48:16 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.83-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution

Sorry if this has been posted already i did a search and only found a bunch of old stuff version 4 Please help

[uxbod]

su - zimbra
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf --socket=/opt/zimbra/db/mysql.sock --check --all-databases

[veronica]

Better generate charts for analysis.
zmstat-chart -s /opt/zimbra/zmstat/<date dir> -d < dest dir>

You might also want to look into stack traces generated.