Zimbra

Rajesh Yadav · #1 (**permalink**) 05-06-2006, 05:55 AM

Hello everybody,

I am using zimbra opensource on FC4. mysql is always showing 99% cpu usage
Pls suggest whats wron ?

KevinH · #2 (**permalink**) 05-08-2006, 10:38 AM

Check the myslow logs in the log directory. How much memory do you have?

JoshuaPrismon · #3 (**permalink**) 05-08-2006, 11:50 AM

Quote:

Originally Posted by Rajesh Yadav

Hello everybody,

I am using zimbra opensource on FC4. mysql is always showing 99% cpu usage
Pls suggest whats wron ?

Are you using DSPAM? I have noticed that the CPU load can spike significantly if you use DSPAM and Mysql according to the old directions...

Rajesh Yadav · #4 (**permalink**) 05-12-2006, 03:32 AM

Quote:

Originally Posted by KevinH

Check the myslow logs in the log directory. How much memory do you have?

i have 1GB ECC MEM, the size of my logger_myslow.log is 2gb. I deleted the same and again its grown upto 19Mb since last 2 days.

KevinH · #5 (**permalink**) 05-14-2006, 04:23 PM

Quote:

Originally Posted by Rajesh Yadav

i have 1GB ECC MEM, the size of my logger_myslow.log is 2gb. I deleted the same and again its grown upto 19Mb since last 2 days.

You could disable the logger cron tasks. This should stop the CPU usage but won't allow you to query the logs.

Downloads