vb.org Archive - View Single Post

pimpfelix · #1 08-25-2008, 09:27 PM

Hey guys.. My VPS was suspended for overloading the CPU.... Here is what they emailed me... They wont turn it back on until I figure out what is causing it.. can someone help?

Overloading with MySQL:

-bash-3.00# mysqladmin processlist;
------ ---------------------- ----------- ----------------- --------- ------ ------------------ ------------------------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info |
------ ---------------------- ----------- ----------------- --------- ------ ------------------ ------------------------------------------------------------------------------------------------------
| 3 | eximstats | localhost | eximstats | Sleep | 1601 | | |
| 3687 | leechprotect | localhost | leechprotect | Sleep | 563 | | |
| 5562 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5563 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5579 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (1) ) |
| 5588 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5592 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5600 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5598 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5597 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5605 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5610 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5612 | remix_remix | localhost | remix_vbulletin | Sleep | 108 | | |
| 5618 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5624 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5625 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5627 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5631 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5639 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5641 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5643 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 418
AND usergroupid NOT IN (3,4) |
| 5651 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5652 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5653 | remix_remix | localhost | remix_vbulletin | Sleep | 96 | | |
| 5655 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5656 | remix_remix | localhost | remix_vbulletin | Sleep | 96 | | |
| 5645 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5658 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5667 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5669 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5672 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5674 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 542
AND usergroupid NOT IN (3,4) |
| 5677 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5678 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 850
AND usergroupid NOT IN (3,4) |
| 5686 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5683 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5696 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5701 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5712 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5745 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5754 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5755 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 5757 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (266) ) |
| 5758 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5774 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5778 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5786 | remix_remix | localhost | remix_vbulletin | Sleep | 71 | | |
| 5792 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5796 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible
|
| 5797 | remix_remix | localhost | remix_vbulletin | Sleep | 69 | | |
| 5794 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (64) ) |
| 5801 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5800 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5808 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible
|
| 5816 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5817 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5819 | remix_remix | localhost | remix_vbulletin | Query | 22 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5835 | remix_remix | localhost | remix_vbulletin | Query | 23 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5833 | remix_remix | localhost | remix_vbulletin | Query | 23 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5831 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5827 | remix_remix | localhost | remix_vbulletin | Query | 22 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5824 | remix_remix | localhost | remix_vbulletin | Sleep | 51 | | |
| 5853 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5854 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01443 seconds Memory Usage 1,829KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: