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 [EMAIL PROTECTED] --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
