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
