I've been experiencing issues with iRedAdmin (and overall system performance) after my amavisd database started to grow.

On my first tests, I found out that iredmail's my.cnf comes with the innodb_file_per_table variable disabled, this leads to a huge performance decrease as in InnoDB, by default, all of the tables are written to one file defined by default at 10MB, with an auto-extend of 8 bytes. Each time it gets to the endpoint, MySQL has to copy the file to another location and add those 8 bytes, before deleting the old one.

My system load is now much lower, but logging in to iRedAdmin-Pro still takes considerable time. I've disabled the amavis database option on settings.ini, and it's ok now, but listing sent/received emails is a nice feature for my customers. Can you describe queries you're performing ? Those could be optimized (or maybe cached), I may take a look at those if you could point out where they are in code.

Re: iRedAdmin and Database Performance

Hi guigouz,

Thanks for your solution (innodb_file_per_table=1), i will add this in next release of iRedMail.About Amavisd queries, all are coded in libs/amavisd/*.py (especially log.py and quarantine.py). Let me know if you have any idea to improve it.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?