Hey all-- I have a problem and a question. My problem is that during busy times on the server, we get errors stating that MySQL couldn't create any threads (error code 11). We are running kernel 2.4.20aa1, but were running 2.4.19 for a long time with the same problem. Has anyone heard of this happening, and if so, what was the resolution?
The question is, what are the performance limits of mysql? I am currently running 4 databases, most with tables containing approx. 300,000 rows, but some well into the millions. During heavy traffic times, we average close to 200 queries/sec, and never really join more than 2 or 3 tables at the most. I am curious because if I can do some tweaking, that'd be great, as I don't really want to buy more hardware, but if I'm reaching the limits of my system, someone please tell me! Specs: Dual Athlon MP 1.2 GHz 2 GB PC2100 DDR 3 IDE hard drives (soon to be an Ultra-Wide SCSI array) mysql 3.23.51-log apache web server php 4.2.3 Slackware Linux 8.1 Kernel 2.4.20aa1 Thanks in advance, Matt -------------------------------------------------------------------------- Matthew Kahn "He who laughs last, laughs alone." --------------------------------------------------------------------- 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
