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
Comment