Okay, I was afraid this was going to happen. 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. I realize this may be a MySQL issue as much as it is a PhpAdsNew issue, but I was really hoping someone here would be able to help me out with some suggestions. Thanks! Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [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
