Hello fellow Zimbra users/admins... I've been experiencing some very high CPU loads on our server. The load is generally caused by the zmlogger process and in turn, mysql. Upon disabling the zmlogprocess cron job as specified in another thread, the load has improved considerably. However, at times, the load still spikes and the system becomes slow. Upon closer inspection, I'm seeing that zmlogger/mysql are killing the machine again. Looking in the /opt/zimbra/logger/db/data/zimbra_logger dir, I'm also seeing HUGE databases such as these:
Our server runs an Intel Core 2 Duo@1.6ghz, 2GB RAM, 2X80GB SATAII drives in RAID1, and about 20 users total with usually around 5 concurrent users accessing using the full AJAX web interface. The platform is CentOS5 running Zimbra 5.0.4_GA_2101.RHEL5
-rw-rw---- 1 zimbra zimbra 12G Jul 25 12:40 raw_logs.MYD
-rw-rw---- 1 zimbra zimbra 3.3G Jul 25 12:40 raw_logs.MYI
Are my system loads incredibly high due to the massive size of the databases? Shouldn't there be a rotation or retention setting for how long to keep these "raw logs"? What can be done to improve the performance of zmlogger/mysql?
All suggestions greatly appreciated. Thank you!