[Dbmail] max mails per folder

2015-11-09 Thread Jure Pečar
Hello, I'm doing some perfomance testing of our dbmail instance. I noticed that If I copy large number of mails into single folder, append starts to get really slow. For example, I have a spam collection of more than 50k sitting on a cyrus imap comfortably in a single folder with append to it

Re: [Dbmail] max mails per folder

2015-11-09 Thread Andrea Brancatelli
My blind shot is that it doesn't depend on dbmail itself, but to MySQL "filling up". Things probably get slow when either: * your controler cache gets filled and the controller starts writing for real to disk * your InnoDB log buffer gets full and the DB has to start committi

Re: [Dbmail] max mails per folder

2015-11-09 Thread Jure Pečar
On Mon, 09 Nov 2015 10:54:48 +0100 Andrea Brancatelli wrote: > > > My blind shot is that it doesn't depend on dbmail itself, but to MySQL > "filling up". > > Things probably get slow when either: > > * your controler cache gets filled and the controller starts writing > for real to d

Re: [Dbmail] max mails per folder

2015-11-09 Thread Andrea Brancatelli
Well, obviously it the depends on the mail amount. We have about 1000 mailboxes with about 350GB of online mail. On spike hours we have a full recycle of the logs in about 10 minutes especially because of circular replication increasing the server activities. Restart after a crash takes more

Re: [Dbmail] max mails per folder

2015-11-09 Thread Jure Pečar
On Mon, 09 Nov 2015 12:38:06 +0100 Andrea Brancatelli wrote: > > > Well, obviously it the depends on the mail amount. > > We have about 1000 mailboxes with about 350GB of online mail. On spike > hours we have a full recycle of the logs in about 10 minutes especially > because of circular rep