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). > >> >

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 fin

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). > >> > >> Reli

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 https://order.m

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 >> FreeBS

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 > explic

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 7821

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 78

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 somewh

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? > > > > T

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 l

RE: slow response time

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

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 res

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 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.

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

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

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 do

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