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

  • jpforte
  • Member
  • Offline
  • From: Belleair Florida USA
  • Registered: 2013-08-24
  • Posts: 58

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.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

jpforte's Website

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,506

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 Reply by jpforte

  • jpforte
  • Member
  • Offline
  • From: Belleair Florida USA
  • Registered: 2013-08-24
  • Posts: 58

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?

jpforte's Website

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,506

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.