Op 8 jun 2010, om 12:36 heeft Paul J Stevens het volgende geschreven: > Erwin Lubbers wrote: >> Hi, >> >> I'm wondering why my dbmail (2.2.13) installation is performing so slow on >> imap search and sort operations. We're using a 64 Gb/SAS MySQL server >> dedicated to dbmail as storage (around 300 Gb in use) and serveral 4 Gb >> machines for the dbmail-imap processes. >> >> I did try a session by telneting to port 143 and than the following happens: >> >> ... LOGIN "username" "password" >> >> Dbmail responsed immediatly with it's OK. Then: >> >> ... SELECT "INBOX" >> >> And again it tells within an eyeblink that there are 1039 messages in the >> INBOX. Then: >> >> ... SEARCH ALL UNDELETED > > That one should really be very fast. > >> >> This response takes 56.3 seconds (!) for those 1039 messages. And a >> >> ... SORT (DATE) US-ASCII ALL UNDELETED >> >> took 38.6 seconds. > > This one is taking too long on my server. Mostly query-bound time. > >> >> In this time there seems to be no query running on the MySQL server (or it >> must run for a very short time so my 1 second updates with mysqladmin >> doesn't seem to catch it). > > That is too weird. Normally slow response is an indication of a poorly > performing query. Did the process involved take up a lot of CPU? Try > running vmstat while your running these commands. >
I did restart dbmail-imapd and then did the search. vmstat shows no significant change in memory usage. CPU load goes from almost 100% idle to around 50% for around 5 seconds (the search answer took much more time to complete). I also started vmstat on the MySQL server and it doesn't show any change in CPU and/or memory usage (only normal small fluctuations). >> >> Anyone an idea how to improve the performance? > > Setup dbmail.conf to log slow queries, and use 'explain' to locate > missing of poorly configured indexes. And post back your findings. > I'm already logging slow queries, but never catched one. Even if I set the values to: query_time_info = 2 query_time_message = 4 query_time_warning = 6 No query is seen as slow. > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
