vb.org Archive - tons of "query killed" in mySQL log files

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - tons of "query killed" in mySQL log files (https://vborg.vbsupport.ru/showthread.php?t=226778)

moleculo

10-25-2009 08:44 PM

tons of "query killed" in mySQL log files

The performance on my site has been horrible lately. Of course, the tech support for my host hasn't been much help. I'm logging about 2500 visitors per day.

In the mySQL logs, I see tons of "query killed" messages related to various vBulletin operations. I suspect that this is the culprit for the performance issue. Does anyone have any advice on what I should look at to resolve this? Is this a host issue or a vBulletin config issue?

BTW, I'm using HostGator.com...they say that they won't alter their mySQL policies to make the "query killed" deal stop. Does anyone else use Hostgator?

Lynne

10-26-2009 03:04 AM

Without seeing specifics of which query is causing the problem, it's hard to help with the problem. It could be a modification causing the problem. Try disabling your modifications/plugins and see if you continue to have the performance issues.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

All times are GMT. The time now is 04:28 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00877 seconds Memory Usage 1,706KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: