The idea is basically the same as Harald pointed out: remove indexes that are not in use, add a couple of new, required by dbmail db queries:
ALTER TABLE dbmail_headervalue
ADD INDEX hash_headervalue (hash, headervalue(255));
ALTER TABLE dbmail_messages
ADD INDEX unique_seen_index (physmessage_id, seen_flag, unique_id),
ADD INDEX status_mailbox_index (physmessage_id, mailbox_idnr,
status);
ALTER TABLE dbmail_sievescripts
ADD UNIQUE INDEX owner_idnr (owner_idnr, name);
--
Best regards,
Pavlo Lavrenenko,
PortaOne, Inc., Junior Software Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624
PortaOne - VoIP Solutions Company
Visit our Website: http://www.portaone.com
mysql-changes.sql
Description: application/sql
oracle-changes.sql
Description: application/sql
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
