The Arcive of Official vBulletin Modifications Site.

adeel80 · #1 09-22-2010, 08:06 PM

Hi, I just received a message from my server guys that until I fix this sql issue, my site won't come back. I have no idea where to start and I can't get a hold of the guy who installed the forum and everything.

Here is the email I received. Please help me out.

---------------------

I've found the source of your issues. It appears to be due to your MySQL queries getting behind. You're going to want to contact your developer to have them look into this to optimize the database.

1197682 root localhost mysql 0 Query show full processlist
1197683 siasat_ad localhost siasat_vbu 5 Query SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1271727491 AND open 10, 1, 0)) AS newthread FROM thread AS thread WHERE forumid = 21 AND sticky = 0 AND visible =
1197685 siasat_ad localhost siasat_vbu 5 Query SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid
1197686 siasat_ad localhost siasat_vbu 5 Query SELECT a.userid, a.attachmentid, a.state, a.contentid, a.filename,fd.userid as uploader, fd.extension, fd.filedataid,fd.dateline, fd.filesize,at.extension, at.mimetype,t
1197687 siasat_ad localhost siasat_vbu 5 Query SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.vis
1197680 siasat_ad localhost siasat_vbu 6 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197681 siasat_ad localhost siasat_vbu 6 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197684 siasat_ad localhost siasat_vbu 6 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197668 siasat_ad localhost siasat_vbu 9 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197661 siasat_ad localhost siasat_vbu 10 Query SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid
1197662 siasat_ad localhost siasat_vbu 10 Query SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.vis
1197663 siasat_ad localhost siasat_vbu 10 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197666 siasat_ad localhost siasat_vbu 10 Query SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid
1197655 siasat_ad localhost siasat_vbu 12 Query SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid
1197657 siasat_ad localhost siasat_vbu 12 Query SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid
1197042 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197156 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197439 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197479 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197520 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197543 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197558 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197576 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197589 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197605 siasat_ad localhost siasat_vbu 13 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197648 siasat_ad localhost siasat_vbu 13 Query SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1285186466 AND open 10, 1, 0)) AS newthread FROM thread AS thread WHERE forumid = 21 AND sticky = 0 AND visible =
1197055 siasat_ad localhost siasat_vbu 14 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197419 siasat_ad localhost siasat_vbu 14 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197583 siasat_ad localhost siasat_vbu 14 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197643 siasat_ad localhost siasat_vbu 14 Query SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.vis
1197647 siasat_ad localhost siasat_vbu 14 Query SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid
1197083 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197089 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197093 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197102 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197117 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197136 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197176 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197202 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197207 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197216 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, threa
1197220 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197221 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197228 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197231 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197232 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197238 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197258 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197272 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197426 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197473 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197477 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197486 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197490 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, threa
1197495 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, threa
1197497 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197498 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197499 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197506 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197514 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197557 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197562 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197574 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197587 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197593 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197599 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197600 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197601 siasat_ad localhost siasat_vbu 15 Query SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid
1197607 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, threa
1197606 siasat_ad localhost siasat_vbu 15 Query UPDATE thread SET views = views + 1 WHERE threadid = 44522
1197608 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thread.dateline, threa
1197613 siasat_ad localhost siasat_vbu 15 Query SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername, thread.postusername, thr

Lynne · #2 09-22-2010, 08:33 PM

Do a search in your files for part of the queries to find where they are from. Like search for "SELECT COUNT(*) AS threads" and "SELECT SQL_CALC_FOUND_ROWS node.nodeid" and "SELECT searchcore.searchgroupid , searchcore.dateline" etc and then you'll find where the queries are from and you can then see if it is something you can turn off.

adeel80 · #3 09-22-2010, 08:39 PM

Hi Lynne,

Thank you for responding. I do not know nothing about these things. Would you be kind enough to help me out? I will happily pay your fees.

Awaiting your response.

p.s. I am on 4.0.3. Would upgrading resolve the issue or it doesnt have anything to do with sql?

MichaelDance · #4 09-23-2010, 12:05 PM

May i ask, is this done via VPS SSH or Cpanel?

Lynne · #5 09-23-2010, 02:08 PM

Quote:

Originally Posted by adeel80

Hi Lynne,

Thank you for responding. I do not know nothing about these things. Would you be kind enough to help me out? I will happily pay your fees.

Awaiting your response.

p.s. I am on 4.0.3. Would upgrading resolve the issue or it doesnt have anything to do with sql?

I don't know if upgrading would resolve the matter - it depends what the queries are from which is why I asked you to find them. For instance, I can't find this one in my 4.0.7 files:
SELECT searchcore.searchgroupid , searchcore.dateline FROM searchcore AS searchcore INNER JOIN thread AS thread ON ( searchcore.contenttypeid = 1 AND searchcore.groupid

I asked you to find them since you have a copy of the files you are using. And, you could also search your plugins. If you have a good text editor, it's very simple to search a directory for text and that is what you should be doing to find the queries.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03668 seconds Memory Usage 2,225KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (5)postbit (5)postbit_onlinestatus (5)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!