List:General Discussion« Previous MessageNext Message »
From:Jeff Kilbride Date:June 19 2002 9:04am
Subject:Re: Don't even know where to start on this one
View as plain text  
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
>

Thread
Don't even know where to start on this oneChris Knipe19 Jun
  • Re: Don't even know where to start on this oneDan Nelson19 Jun
  • Re: Don't even know where to start on this oneChris Knipe19 Jun
    • Re: Don't even know where to start on this oneDan Nelson19 Jun
  • Re: Don't even know where to start on this oneDr. Frank Ullrich19 Jun
  • Re: Don't even know where to start on this oneJeff Kilbride19 Jun
  • Re: Don't even know where to start on this oneEivind A. Sivertsen19 Jun
RE: Don't even know where to start on this oneSimon Green19 Jun