1 (edited by jpforte 2013-10-18 01:19:18)

Topic: iRedadmin login extremely slow IO stat show 97% disk utilization

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version: iRedmail PRO iRedMail-0.8.5  (1.7.0)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS release 6.4 (Final)
- Related log if you're reporting an issue:
====

Logging into iredadmin is extremely slow.

using iostat disk utilization is 97%

What do I do?

We have 230G of email on this server

I notice that /var/lib/mysql/ibdata1 has grown HUGE (5.9G) as well.

2

Re: iRedadmin login extremely slow IO stat show 97% disk utilization

jpforte wrote:

- iRedMail version: iRedmail PRO iRedMail-0.8.5  (1.7.0)

Did you execute script "tools/cleanup_amavisd_db.py" shipped in iRedAdmin-Pro daily to clean up old SQL records in Amavisd database?

jpforte wrote:

I notice that /var/lib/mysql/ibdata1 has grown HUGE (5.9G) as well.

Reference: http://stackoverflow.com/questions/3456 … e-in-mysql

3

Re: iRedadmin login extremely slow IO stat show 97% disk utilization

NO. I did not and was not aware of this. Should this go in the Cron?

4

Re: iRedadmin login extremely slow IO stat show 97% disk utilization

jpforte wrote:

NO. I did not and was not aware of this. Should this go in the Cron?

Yes.
You can execute it manually first, then setup a daily cron job to do this for you. You can follow the instruction in this file (tools/cleanup_amavisd_db.py) to setup cron job.