And you might want to choose Linux over FreeBSD for your MySQL machines.
There have been a lot of posts about random CPU runaways under load with
FreeBSD. I'm not sure if it affects single or multi processor machines, but
it made me think twice...
--jeff
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "Chris Knipe" <savage@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, June 18, 2002 7:46 PM
Subject: Re: Don't even know where to start on this one
> In the last episode (Jun 19), Chris Knipe said:
> > > > My PHP code also use persistent connections, and I don't think this
is
> > the
> > > > problem, but basically, how more queries I throw at MySQL how more
my PC
> > > > crawls down to a halt - even after the application with the queries
> > > > disconnected from the database. I can understand that my system may
> > take
> > >
> > > Are you swapping?
> >
> > Allot....
> >
> > The development box is only a 166MMX with 64MB ram unfortunately :-(
> > NT's virtual memory is on average 220MB / 230MB with a peak load
> > currently at 250MB... Perhaps it is just NT being funny with me...
> > Hopefully I'll have the DBs on a decent FreeBSD box soon....
>
> Until you get more memory, edit your my.cnf and lower key_buffer_size
> and sort_buffer way down, like to 8MB and 128k. See
> http://www.mysql.com/doc/S/e/Server_parameters.html
>
> --
> Dan Nelson
> dnelson@stripped
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread112436@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jeff=kilbride.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
