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