1 Topic by rafaello

  • rafaello
  • Member
  • Offline
  • Registered: 2014-02-01
  • Posts: 16

Topic: how to clean the mysql base msgrcpt msgs amavis

======== Required information ====
- iRedMail version:  iRedMail-0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  LDAP/MySQL
- Linux/BSD distribution name and version:  DEBIAN 7
- Related log if you're reporting an issue:  ==== 

Hi!
I recently checked the mysql database and saw that base msgrcpt and msgs in base amavis acquired a very large size.
Then I began to search for information on the Internet and found the following
http://www.iredmail.org/forum/topic4350 … nence.html
But at the moment I do not have iRedAdmin-Pro, only iRedAdmin
In this regard, I have a question. In order to clear the database table mskl msgrcpt, msgs amavis, I need to:
1. Buy a license for iRedAdmin-Pro
2. Execute command TRUNCATE TABLE table_name for each database table msgrcpt and msgs
3. Make a script
http://gogs.info/books/debian-mail/chun … mavis.html
Section 6.3.2. Maintenance
4. Or something else .....

----

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: 31,094

Re: how to clean the mysql base msgrcpt msgs amavis

rafaello wrote:

2. Execute command TRUNCATE TABLE table_name for each database table msgrcpt and msgs

Truncating tables is ok if you don't need these log. NOTE: It doesn't store mail messages.

Or, you can comment out '@storage_sql_dsn' line in Amavisd config file to stop logging these info in Amavisd database.

3 Reply by rafaello

  • rafaello
  • Member
  • Offline
  • Registered: 2014-02-01
  • Posts: 16

Re: how to clean the mysql base msgrcpt msgs amavis

many thanks!!!!!!

ZhangHuangbin wrote:
рафаэлло wrote:

2. Выполнить команду TRUNCATE TABLE имя таблицы для каждой таблицы базы данных msgrcpt и сбщ

Усечение таблиц ок, если вам не нужны эти журнал. Примечание: это не хранения сообщений электронной почты. Или, вы можете закомментировать '@storage_sql_dsn' line в Amavisd конфигурационный файл, чтобы остановить вырубку этих info в Amavisd базы данных.