jim barchuk wrote: > Hi Ryan! > > > Today after my server got a real traffic hit for the first time since I > > installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how > > it happened: watching the "top" load levels, I saw it slow creep up about to > > 3, then rockets quickly to 30s, 40s, and on!! MySQL was at this time taking > > up 100% of both of the processors in the server. There were about 40 or so > > MySQL processes spawned at this point. Doing a 'mysqladmin processlist' > > command on the server showed me a VERY LONG LIST of processes that were > > open, a lot of which were PhpAdsNew UPDATE commands. > > > > The system it is on is a Dual-Athlon 1.2 GHz with 1 GB of memory. I have > > heard of systems that run at 450 MHz to be able to handle more ad views than > > this system is taking. I have the latest MySQL and PHP, all on Red Hat 7.1. > > This is the second ad software that has done this, so I don't think the > > problem is so much in the software, but something about my MySQL config or > > setup. > > Obviously the system should handle the load. > > At http://www.mysql.com/doc/ do a search for multiple processors. There's > a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that > might help.
And don't forget to make sure you have good/needed indexes. (e.g See the manual entry on "EXPLAIN", run myisamchk -a, etc..). b. --------------------------------------------------------------------- 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
