vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   queries getting into sleep state? mysql connections question... (https://vborg.vbsupport.ru/showthread.php?t=165325)

afullcup 12-16-2007 09:02 PM
queries getting into sleep state? mysql connections question...
 
I have had a lot of problems with my site getting very slow. It is a pretty busy board, but I also have a lot of resources. I just had my server folks look into it today and here is what they told me:

Quote:
We have tweaked some Mysql variables and restarted the service. But still some queries are getting in sleep state, that is because of the bad coding style. You need to take care of mysql connection open, close and other query managements in the code for avoiding this.
So... how do I figure out where this is happening? I do have way more hacks/mods than I probably should, but removing them all isn't really a good option for me. Is there an easy way to figure out which hacks are making database calls? (like something to "grep" for in the files I've downloaded?)

Any insight into this would be greatly appreciated!!!

--------------- Added [DATE]1197919160[/DATE] at [TIME]1197919160[/TIME] ---------------

anyone?


All times are GMT. The time now is 09:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01734 seconds
  • Memory Usage 1,708KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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