Re: slow response time

2004-07-08 Thread Egor Egorov
Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x.

Re: slow response time

2004-07-08 Thread Jeremy Zawodny
On Thu, Jul 08, 2004 at 09:23:17PM +0300, Egor Egorov wrote: Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and

Re: slow response time

2004-07-07 Thread Harald Fuchs
In article [EMAIL PROTECTED], Jeremy Zawodny [EMAIL PROTECTED] writes: Using the query cache at all? Not sure... I'm using the values for caches and whatnot from the my-large.cnf in the distribution. The my-large.cnf I'm looking at has a 16M query cache, but doesn't explicitly turn it

Re: slow response time

2004-07-07 Thread Egor Egorov
Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL

Re: slow response time

2004-07-07 Thread Egor Egorov
Charles Sprickman [EMAIL PROTECTED] wrote: The hardware is a dual Athlon MP-1600 smp box with 1GB of RAM. BTW, user-level threads don't scale on more than one CPU. I.e. different threads cannot run on different CPUs on FreeBSD 4. -- For technical support contracts, goto

Re: slow response time

2004-07-07 Thread Jeremy Zawodny
On Wed, Jul 07, 2004 at 07:11:17PM +0300, Egor Egorov wrote: Jeremy Zawodny [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and

Re: slow response time

2004-07-06 Thread Egor Egorov
Charles Sprickman [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL

Re: slow response time

2004-07-06 Thread Jeremy Zawodny
On Tue, Jul 06, 2004 at 05:07:24PM +0300, Egor Egorov wrote: Charles Sprickman [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance

Re: slow response time

2004-07-06 Thread Charles Sprickman
On Tue, 6 Jul 2004, Egor Egorov wrote: Charles Sprickman [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux Threads). Reliability and performance is not what you should

Re: slow response time

2004-07-06 Thread Jeremy Zawodny
On Tue, Jul 06, 2004 at 12:48:39PM -0400, Charles Sprickman wrote: On Tue, 6 Jul 2004, Egor Egorov wrote: Charles Sprickman [EMAIL PROTECTED] wrote: So I haven't really done much to optimize things, as this seems like a fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build

Re: slow response time

2004-07-06 Thread Charles Sprickman
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

RE: slow response time

2004-07-06 Thread Chip Bell
Are you running spam assassin? I'm finding that my slow query log is showing the spam queries to really be dragging. -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

RE: slow response time

2004-07-06 Thread Charles Sprickman
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

Re: slow response time

2004-07-06 Thread Jeremy Zawodny
On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: 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

Re: slow response time

2004-07-06 Thread Charles Sprickman
On Tue, 6 Jul 2004, Jeremy Zawodny wrote: On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: 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

Re: slow response time

2004-07-06 Thread Jeremy Zawodny
On Tue, Jul 06, 2004 at 04:26:04PM -0400, Charles Sprickman wrote: On Tue, 6 Jul 2004, Jeremy Zawodny wrote: On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: On Tue, 6 Jul 2004, Jeremy Zawodny wrote: Do you have a summary of the poor performance somewhere? Or at

Re: slow response time

2004-07-06 Thread Charles Sprickman
On Tue, 6 Jul 2004, Jeremy Zawodny wrote: procs memory pagedisks faults cpu r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy 0 13 0 782108 61388 748 0 0 0 863 0 13 0 399 3756 276 23 95 2 13 0 788184

Re: slow response time

2004-07-06 Thread Jeremy Zawodny
On Tue, Jul 06, 2004 at 08:05:43PM -0400, Charles Sprickman wrote: On Tue, 6 Jul 2004, Jeremy Zawodny wrote: procs memory pagedisks faults cpu r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy 0 13 0 782108 61388

Re: slow response time

2004-07-02 Thread Charles Sprickman
Hi, Just following up with some more information... I've been seeing a bit better behaviour by going from LinuxThreads to FreeBSD native threads. My hunch is also that this is somehow related to qmail; something of a contention issue between qmail and mysql. As I said, system load remains low.

slow response time

2004-07-01 Thread Charles Sprickman
Hi, I have (what I thought) was a fairly small mysql setup. It's backing a vpopmail installation, and basically just handling alot of SELECTs. In the process of delivering mail, the db gets hit a few times: -initial check that the user exists during smtp conversation -lookup for homedir during