Upgrade and now hosting company complaining

[Rizzo]

After i upgraded to 3.8 they are complaining that i'm putting too much load on the sql. Can someone help me - they say they'll suspend my account if i don't.

[email protected] [~]# mysqladmin processlist | grep mummybra
| 87  | mummybra_vbullet | localhost | mummybra_forum       | Query   | 143  | Sorting result       | SELECT post.postid
| 107 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 138  | Copying to tmp table | SELECT COUNT(post.dateline) AS cybpcount, post.userid, post.visible, post.dateline, thread.forumid,  |
| 132 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 124  | Locked               | UPDATE vBuser
| 138 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 123  | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 148 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 122  | Locked               | SELECT
| 185 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 103  | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 223 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 82   | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 260 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 61   | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 261 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 60   | Sorting result       | SELECT post.postid
| 292 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 39   | Sorting result       | SELECT post.postid
| 316 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 28   | Locked               | SELECT
| 330 | mummybra_vbullet | localhost | mummybra_forum       | Query   | 18   | Sorting result       | SELECT post.postid








[email protected] [~]# mysqladmin processlist | grep mummybra
| 107  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2278 | Copying to tmp table | SELECT COUNT(post.dateline) AS cybpcount, post.userid, post.visible, post.dateline, thread.forumid,  |
| 132  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2264 | Locked               | UPDATE vBuser
| 138  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2263 | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 148  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2262 | Locked               | SELECT
| 185  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2243 | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 223  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2222 | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 260  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2201 | Locked               | SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
| 316  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2168 | Locked               | SELECT
| 405  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2118 | Locked               | SELECT albumpicture.*, album.*, user.username, user.usergroupid,
| 430  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2123 | Locked               | SELECT
| 467  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2083 | Locked               | SELECT
| 468  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2095 | Locked               | SELECT albumpicture.*, album.*, user.username, user.usergroupid,
| 484  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2071 | Locked               | SELECT
| 501  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2022 | Locked               | SELECT
| 517  | mummybra_vbullet | localhost | mummybra_forum | Query   | 2003 | Locked               | SELECT
| 1430 | mummybra_vbullet | localhost | mummybra_forum | Query   | 208  | Locked               | SELECT COUNT(postid) AS posts,
| 1447 | mummybra_vbullet | localhost | mummybra_forum | Query   | 253  | Locked               | SELEC

[Jake Bunce]

Are you on a shared server? Resources are limited on shared servers because of other sites on the same server.

Here are some intensive features you can toggle to help your resource usage:

Admin CP -> vBulletin Options -> General Settings -> Thread/Forum Read Marking Type

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Message Searching Options -> Search Engine Enabled

Admin CP -> vBulletin Options -> Email Options -> Use Mailqueue System

Admin CP -> vBulletin Options -> Server Settings and Optimization Options -> Update Thread / Attachment Views Immediately

Admin CP -> vBulletin Options -> Plugin/Hook System -> Enable Plugin/Hook System

If you continue to have problems then I recommend you post in the Server Configuration forum. Post the info requested in this thread and they will be able to make recommendations:

http://www.vbulletin.com/forum/showthread.php?t=70117

But if you are on a shared server then they will probably just tell you to upgrade to a better server.