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. Have a :) day! jb ob-filter-words: table sql database -- jim barchuk [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
