Upgrade/iRedMail/0.7.3-0.7.4
From iRedMail
(Difference between revisions)
| Line 15: | Line 15: | ||
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); | ||
</pre>}} | </pre>}} | ||
Revision as of 18:02, 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 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); |
