On Tue, 6 Jul 2004, Chip Bell wrote: > Are you running spam assassin? I'm finding that my slow query log is > showing the spam queries to really be dragging.
I am, but that's on three other boxes. This one is just qmail/vpopmail (vpopmail hits mysql for user info). If I had to guess at when exactly this happens, I'd say it's when qmail starts running through it's queue of undeliverable junk. vmstat reports a ton of "context switch" hits when this happens. Plenty of memory though, and interactive performance of other services (http, smtpd, cli) is fine. I also see that vpopmail simply doesn't call mysql_close() in many places; the vpopmail folk claim that this is "OK", but I wonder if it's upsetting mysql in some way. Thanks, Charles > -----Original Message----- > From: Charles Sprickman [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 06, 2004 2:29 PM > To: [EMAIL PROTECTED] > Cc: Egor Egorov > Subject: Re: slow response time > > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > Do you have a summary of the poor performance somewhere? Or at least > > a sense of where you think the bottleneck is? > > The best I can tell you is that mysql + moderate qmail load on the same > box causes problems. I don't know if this is a scheduler issue with > FreeBSD, or just qmail telling me that I should be using Postfix. > > Out of the blue mysql will start logging stuff like this in the slow > query > log: > > # administrator command: Ping; > # [EMAIL PROTECTED]: squirrelmail[squirrelmail] @ localhost [] > # Query_time: 47 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 > # administrator command: Ping; > # [EMAIL PROTECTED]: vpopmail[vpopmail] @ localhost [] > # Query_time: 48 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 > > Load is moderate, but not so bad that any other services on here are > affected in any perceptible way. > > Thanks, > > Charles > > > Jeremy > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > [book] High Performance MySQL -- http://highperformancemysql.com/ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
