Check your my.cnf configuration file. MySQL has a configurable maximum answer size. I think the default value is about 1 MB, so this could be what is causing the poor database performance. Try cranking up this value. Check mysql documentation for more details..
There might as well be more performance tuning you might be able to do with mysql, like allowing the mysql server to use more RAM, etc.. check out the doc.. Cedric On July 27, 2002 12:57 am, Mark Mackay wrote: > I'm just testing some large mailboxes for performance handling, etc and > noticed that checking for new mail seemed to pause for up to 5-10 seconds > or so before continuing. When looking at the mysql query logs, the > following > > seemed to be holding things up: > > SELECT messageblk FROM messageblks WHERE message_idnr = 323 ORDER BY > > messageblk_idnr > > This was using IMAP, and message 323 was a 10Mb file. The code doing this I > believe is dbmsgbuf.c. It seems to load the entire message into memory or > at least process it on the database before starting to send it to the user. > > I'm running a P4 1.8G with 1Gb memory as the database server and the same > spec for the imap server; both with ata66 drives. All-in-all dbmail has > been performing OK, only curbed by the noticeable pausing. > > Maybe this is unavoidable, in which case I'll just have to boost specs -- > but maybe the message could be loaded into chunks from mysql (using a limit > X,100 and repeating the query every 100 blocks or so). > > FYI. > > /Mark > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
