Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users
dbmail performance test
 

Index | Next | Previous | View Flat


a.babic at ecircle

May 27, 2009, 3:01 PM


Views: 798
Permalink
dbmail performance test

Hi,

I am using dbmail for several years. Recently I have made performance
test of dbmail and cyrus. I have 350 users in dbmail with total 4
million mails.
The biggest mailbox has a bit more than 150000 mails.

Then I created the same users for cyrus and with imapsync copied all
mails from dbmail to cyrus. Yes, it took few days to finish.

This is an test environment so I had exclusive access to it.

Dbmail version 2.2.11 compiled from source
Cyrus version 2.2.13-14+b3 (debian package)

Both imaps use mysql for authentication.

Database dbmail took 48G while cyrus mail storage had 30G for the same
amount of mails.

I run simple test with expect scripts and measuring time difference
between establishing and closing connection to each imap.

What I have got from tests is that search is much faster on dbmail and
fetch is much faster on cyrus.

For example on the mailbox which had 39661 unread mails search on cyrus
imap took 20 seconds. The same operation on identical mailbox on
dbmail took 12.7 seconds.

On the other side, fetching headers from all mails in inbox with "fetch
1:* body[header]" took on dbmail 20 seconds while the same operation
on cyrus took 3 seconds.

I want to point that originaly I had mysql parameter tmp_table_size set
to 30M and then search on dbmail took ages on 3000 big maibox.
After I increased this parameter to 500M search was flying and tests
mentioned above are done when tmp_table_size was set to 500M.

I am using roundcube webmail as front end for dbmail imap server and
after login it takes ages to open huge mailbox. I would appreciate if
you know and tell me if there is any "trick" to increase speed of fetch
on dbmail.


Regards,

Andreja
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Subject User Time
dbmail performance test a.babic at ecircle May 27, 2009, 3:01 PM
    Re: dbmail performance test gordan at bobich May 27, 2009, 3:50 PM
    Re: dbmail performance test josh at worldhosting May 27, 2009, 4:06 PM
    Re: dbmail performance test vulture at netvulture May 27, 2009, 6:46 PM
        Re: dbmail performance test a.babic at ecircle May 28, 2009, 12:36 AM
    Re: dbmail performance test michael.monnerie at is May 28, 2009, 1:42 AM
    Re: dbmail performance test qingran.xia at gmail May 28, 2009, 3:17 AM
    Re: dbmail performance test a.babic at ecircle Jun 3, 2009, 2:31 PM
    Re: dbmail performance test vulture at netvulture Jun 3, 2009, 9:27 PM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.