donjoan
09-04-2008, 09:13 PM
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 |
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 |