Announcement

Collapse
No announcement yet.

Upgrade and now hosting company complaining

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Upgrade and now hosting company complaining

    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.

    Code:
    [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
    http://www.mummybrain.org.nz

  • #2
    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.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X