On Mon, Oct 06, 2003 at 12:48:16PM -0500, Bret Baptist wrote: > Well I think we can rule out the postgres libs, since I am running MySQL. I > am thinking it must be the SQL code they are using, instead of idling while > waiting for the client to download, it is just taking all the cpu.
I haven't seen the high load cpu usage, but the imap server does seem to have some problems too. Looking at my mysql logs, I often see it running the same queries many times in a row while retrieving a message. For example: 031006 11:38:15 9331 Query SELECT messageblk FROM messageblks WHERE message_idnr = 9051 ORDER BY messageblk_idnr 031006 11:38:18 9331 Query SELECT messageblk FROM messageblks WHERE message_idnr = 9051 ORDER BY messageblk_idnr 031006 11:45:56 9331 Query SELECT messageblk FROM messageblks WHERE message_idnr = 9051 ORDER BY messageblk_idnr It is also very slow retreiving large messages (those with multiple messageblks), sometimes up to 10 minutes for a 2MiB file. The load is not high during this time, so I'm not sure what it's doing. Notice the timestamps between the second and third queries above. I'm using the debian package 1.1.20030726-1. xn
