My opinion only....if you are a dot com, and are having critical problems with a production server that you rely on to make your $$$, then you should suck it up and pay for support. We pay $40k/year for commercial support on our "important" Sybase database, and its worth every penny. Regards, Gary "SuperID" Huntress ======================================================= FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org:27960 (AT&T is currently blocking 80 and 8080) ----- Original Message ----- From: "Ryan Shrout" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 18, 2001 1:06 PM Subject: MySQL Spawns Many Processes and Uses 100% CPU! PART #2 CONTINUED FROM PART #1 While this happens, I was able to do a "mysqladmin processlist" command and here is the result: [root@dagger /root]# mysqladmin processlist -p Enter password: +--------+-------+-----------+-----------+---------+------+----------------+ ---- ---------------------------------------------------------------------------- ---- ------------------+ | Id | User | Host | db | Command | Time | State | Inf o | +--------+-------+-----------+-----------+---------+------+----------------+ ---- ---------------------------------------------------------------------------- ---- ------------------+ | 649586 | amdmb | localhost | forum | Quit | 48 | | | | 649594 | amdmb | localhost | dotbanner | Query | 4 | Locked | upd ate advertisers set Shown="6613775" where UserName="TCComputers" | | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up | SEL ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10 | | 649598 | amdmb | localhost | dotbanner | Query | 8 | Locked | sel ect * from advertisers where UserName="Iwill" | | 649601 | amdmb | localhost | forum | Sleep | 36 | | | | 649609 | amdmb | localhost | Amdmb | Init DB | 1 | cleaning up | | | 649614 | amdmb | localhost | forum | Query | 0 | Opening tables | SEL ECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1' | | 649629 | amdmb | localhost | forum | Query | 4 | | | | 649630 | amdmb | localhost | dotbanner | Query | 4 | Locked | sel ect * from advertisers where UserName="DualAthloncom" | | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='53042' | | 649644 | amdmb | localhost | forum | Query | 68 | cleaning up | SEL ECT COUNT(*) AS threads FROM thread WHERE thread.forumid='19' AND thread.visible =1 AND lastpost > | | 649649 | amdmb | localhost | dotbanner | Query | 80 | cleaning up | upd ate advertisers set Shown="6613772" where UserName="TCComputers" | | 649658 | amdmb | localhost | dotbanner | Query | 8 | Locked | upd ate advertisers set Shown="6613774" where UserName="TCComputers" | | 649663 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='51192' | | 649664 | amdmb | localhost | dotbanner | Quit | 72 | | | | 649666 | amdmb | localhost | forum | Query | 67 | | | | 649667 | amdmb | localhost | forum | Query | 68 | | | | 649673 | amdmb | localhost | dotbanner | Query | 0 | Locked | sel ect * from advertisers where UserName="DualAthloncom" | | 649678 | amdmb | localhost | Amdmb | Quit | 53 | cleaning up | | | 649685 | amdmb | localhost | forum | Quit | 28 | | | | 649690 | amdmb | localhost | dotbanner | Query | 8 | Locked | sel ect UserName, Weight from advertisers where (Display_Zone like "%left_125_125%" OR Display_Zone = | | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up | sel ect UserName, Weight from advertisers where (Display_Zone like "%VantecHome%" OR Display_Zone = " | | 649695 | amdmb | localhost | forum | Quit | 4 | | | | 649706 | amdmb | localhost | dotbanner | Query | 4 | Locked | sel ect UserName, Weight from advertisers where (Display_Zone like "%VantecHome%" OR Display_Zone = " | | 649709 | amdmb | localhost | forum | Query | 0 | Opening tables | SEL ECT * FROM usergroup WHERE usergroupid=1 | | 649711 | amdmb | localhost | dotbanner | Query | 0 | Locked | sel ect * from advertisers where UserName="TCComputers" | | 649712 | amdmb | localhost | forum | Quit | 28 | | | | 649713 | amdmb | localhost | dotbanner | Query | 55 | cleaning up | sel ect * from advertisers where UserName="Iwill" | | 649715 | amdmb | localhost | dotbanner | Query | 3 | cleaning up | sel ect UserName, Weight from advertisers where (Display_Zone like "%left_125_125%" OR Display_Zone = | | 649716 | amdmb | localhost | dotbanner | Query | 8 | Locked | upd ate advertisers set Shown="1722353" where UserName="Vantec" | | 649719 | amdmb | localhost | dotbanner | Query | 55 | | | | 649720 | amdmb | localhost | Amdmb | Query | 48 | | | | 649721 | amdmb | localhost | dotbanner | Query | 55 | cleaning up | sel ect * from advertisers where UserName="Iwill" | | 649722 | amdmb | localhost | forum | Query | 4 | Sorting result | SEL ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10 | | 649723 | amdmb | localhost | dotbanner | Query | 8 | Locked | sel ect UserName, Weight from advertisers where (Display_Zone like "%left_125_125%" OR Display_Zone = | | 649728 | amdmb | localhost | dotbanner | Query | 0 | Locked | upd ate advertisers set Shown="571682" where UserName="DualAthloncom" | | 649824 | root | localhost | | Query | 8 | | sho w processlist | ...... more and more This is obviously VERY much too long, but I can't seem to figure out what is going on. I am in dire need of help here!! I once thought that the kernel was the problem, but I upgraded that and the problem returned. I upgraded MySQL and still the problem returned. I upgraded the hard drive bandwidth (MB/sec) thinking that might improve it, but nothing I have tried keeps the problem away for more than a day. If you need any more information from me (including database table formats, queries, etc) please let me know! I will be more than happy to give them to you!! Thanks to anyone who helps me out!!! 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
