The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
load problem from database
i have load very high and the forum must of the day not open
can any one help to fix that please i have only this site in the server and it not very bic site - Single CPU - Core2Duo 3.00Ghz - 4GB - 2X250GB SATA - 2000GB In/Out - 5 Vlan Ips (/29) - CentOS - Cpanel/WHM root@host7688 [~]# mysqladmin processlist +------+--------------+-----------+-----------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-----------+-----------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+ | 3741 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 1109 | | | | 3777 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 1011 | | | | 3896 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 989 | | | | 3999 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 948 | | | | 4083 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 920 | | | | 4176 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 878 | | | | 4178 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 878 | | | | 4191 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 856 | | | | 4303 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 816 | | | | 4390 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 796 | | | | 4403 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 768 | | | | 4435 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 763 | | | | 4522 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 729 | | | | 4580 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 701 | | | | 4957 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 505 | | | | 5063 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 446 | | | | 5238 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 370 | | | | 5279 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 306 | | | | 5281 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 306 | | | | 5305 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 306 | | | | 5384 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 241 | | | | 5389 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 241 | | | | 5419 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 241 | | | | 5429 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 238 | | | | 5567 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 188 | | | | 6021 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 46 | | | | 6067 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Sleep | 13 | | | | 6073 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 8 | Locked | UPDATE user SET lastactivity = 1220565897 WHERE userid = 220654 | | 6079 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 6 | Locked | UPDATE user SET lastactivity = 1220565902 WHERE userid = 224382 | | 6093 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 8 | Locked | UPDATE user SET posts = posts + 1, usertitle = '<img border=\"0\" src=\"http://wnasa.com/vb/imag | | 6095 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 8 | Locked | UPDATE user SET posts = posts + 1, lastpost = 1220565908, lastpostid = 3462721 WHERE userid = | | 6124 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 8 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6126 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 8 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6129 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 7 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6130 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 7 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6131 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 7 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6136 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 6 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6140 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 5 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6141 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 5 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6142 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 4 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6144 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 4 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6145 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 3 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6147 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 2 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6150 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 1 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6151 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 1 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6154 | xxxxxxxx_Mike | localhost | xxxxxxxx_vb | Query | 0 | Sorting result | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las | | 6157 | root | localhost | | Query | 0 | | show processlist | |
#2
|
|||
|
|||
Please post an optimisation request in http://www.vbulletin.com/forum/forumdisplay.php?f=14
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|