1 Topic by darth_wells

  • darth_wells
  • Member
  • Offline
  • Registered: 2011-10-07
  • Posts: 78

Topic: MAIL QUEUES DON'T PROCESS IF OPTIMIZE ON MYSQL AMAVISD DATABASE

- iRedMail version:   0.74
- Linux/BSD distribution name and version:    Debian

http://www.ijs.si/software/amavisd/README.sql-mysql.txt

Suggested to:
Optionally, optimize tables once in a while:
OPTIMIZE TABLE msgs, msgrcpt, quarantine, maddr;

I tried this and all mail (outbound and inbound) just started queuing and nothing was processing, until I rebooted the server.

Is this normal?

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: MAIL QUEUES DON'T PROCESS IF OPTIMIZE ON MYSQL AMAVISD DATABASE

I didn't try it before, but i guess it causes database lock, or MySQL is too busy.
You should check MySQL state.