Re: System load - 0.5 on Linux, 75 on Solaris!

2003-12-16 Thread Chris Allen
On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote: > > > >The DB is on a vanilla UFS partition. Do you have any references about > >this? I couldn't find anything on the MySQL site... > > > > > > > There's nothing on the MySQL site but I do remember reading a comparison > between Solar

Re: System load - 0.5 on Linux, 75 on Solaris!

2003-12-16 Thread Chris Nolan
Chris Allen wrote: On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote: There are a few things that could be happening: Are you using persistant connections from your web servers, Yes - with Apache::DBI under mod_perl Well, that's one option out of the way,,, 2. Which FS are

Re: System load - 0.5 on Linux, 75 on Solaris!

2003-12-16 Thread Chris Allen
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote: > There are a few things that could be happening: > > Are you using persistant connections from your web servers, Yes - with Apache::DBI under mod_perl > 2. Which FS are you using? The native Solaris FS needs a bit of tuning > to get

Re: System load - 0.5 on Linux, 75 on Solaris!

2003-12-16 Thread Chris Nolan
There are a few things that could be happening: 1. Solaris 8 uses many-to-many threads in "Solaris threading mode" and 1:1 in POSIX threading mode. I'm not sure which functionality the MySQL binaries exercise, but 1:1 seems to be less intensive. Regardless, Solaris thread creation tends to be s

System load - 0.5 on Linux, 75 on Solaris!

2003-12-16 Thread Chris Allen
I have a MySQL replication slave running 3.23.52 on a 2.4.18 linux box with 1.2GHz P3 and 512MB of memory. The box serves three web servers and runs at about 70 queries per second most of the time, with system load at about 0.5 MySQL is the precompiled RPM from mysql.com Recently I tried to