Upgrade/iRedMail/0.7.3-0.7.4
From iRedMail
(Difference between revisions)
| Line 13: | Line 13: | ||
$ mysql -uroot -p | $ mysql -uroot -p | ||
mysql> USE amavisd; | mysql> USE amavisd; | ||
| + | mysql> ALTER TABLE msgs ADD INDEX maddr_idx_email (email); | ||
| + | mysql> ALTER TABLE msgs ADD INDEX maddr_idx_domain (domain); | ||
mysql> ALTER TABLE msgs ADD INDEX msg_idx_content_time_num (content, time_num); | mysql> ALTER TABLE msgs ADD INDEX msg_idx_content_time_num (content, time_num); | ||
mysql> ALTER TABLE msgs ADD INDEX msgs_idx_mail_id (mail_id); | mysql> ALTER TABLE msgs ADD INDEX msgs_idx_mail_id (mail_id); | ||
mysql> ALTER TABLE msgs ADD INDEX quar_idx_mail_id (mail_id); | mysql> ALTER TABLE msgs ADD INDEX quar_idx_mail_id (mail_id); | ||
</pre>}} | </pre>}} | ||
Revision as of 18:26, 24 August 2011
Contents |
WORKING IN PROGRESS, DO *NOT* APPLY IT.
General
Add INDEXes for Amavisd database
| Terminal: |
$ mysql -uroot -p mysql> USE amavisd; mysql> ALTER TABLE msgs ADD INDEX maddr_idx_email (email); mysql> ALTER TABLE msgs ADD INDEX maddr_idx_domain (domain); mysql> ALTER TABLE msgs ADD INDEX msg_idx_content_time_num (content, time_num); mysql> ALTER TABLE msgs ADD INDEX msgs_idx_mail_id (mail_id); mysql> ALTER TABLE msgs ADD INDEX quar_idx_mail_id (mail_id); |
