Hi everyone,
The indexes and foreign key statements below are great - just make sure
you run dbmail-maintanence -f first! You'll probably get plenty of
complaints about unconnected messages otherwise.
Chris
Richard Houston wrote:
All,
First off I love what the developers are doing with dbmail. An awesome
idea that addresses several issues I have been having with retention and
centralized storage with almost infinite scalability.
My only issue was performance coming from using a courier-imap with
postfix.
Now, with these index additions of Paul's has improved my performance to
almost the same as courier-imap. Has anyone had any issues with these
modifications? Are there any draw backs the the indexes?
I plan on making dbmail the center piece of a scalable mail hub that
will include other feature and am wondering what kind of large scale,
both number of users and message throughput per day, people have set up
and in production.
Thanks for all the great information on this list and the the dbmail
developers, keep up the excellent work.
Thanks again,
Rich
On Wed, 2003-04-02 at 16:57, Paul Stevens wrote:
Ryan Butler wrote:
Do you have a alter table statement floating around that modifies the
stock table to use your indexes and constraints?
Hi Ryan,
I'm currently using:
alter table mailboxes add index (owner_idnr);
alter table mailboxes add index (name);
alter table mailboxes add index (is_subscribed);
alter table messages add index(mailbox_idnr);
alter table messages add index(seen_flag);
alter table mailboxes add foreign key (owner_idnr) references
users(user_idnr) on delete cascade;
alter table messages add foreign key (mailbox_idnr) references
mailboxes(mailbox_idnr) on delete cascade;
alter table messageblks add foreign key (message_idnr) references
messages(message_idnr) on delete cascade;
But mind you, I'm no innodb nor sql expert. My experience is mostly
limited to good-old (my)isam limited sql. So any ideas for improvements
that are actually based on a closer examination of the actual queries
used by dbmail are most welcome I'm sure. I guess more experience with
larger deployments will tell.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
