vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Lots of MySQL Errors (https://vborg.vbsupport.ru/showthread.php?t=193643)

droid101 10-14-2008 10:34 PM

Lots of MySQL Errors
 
Hey guys, I'm getting a lot of MySQL error emails from database hangups.

I've gathered from vBulletin support and my host's support that the issue is because many of the queries are taking too long and timing out.

What can I do to reduce queries? General tips, or checking my site for more specific help would be nice. :)

Either way, thanks!

www.constantcognizance.com

noppid 10-14-2008 10:41 PM

You probably have a modification that is table walking a big database. But that's a guess.

Turn off the modifications system and see what happens. Or, ask your host what queries are in the mysql slow queries log causing the bottleneck.

Have you posted the specific error? The vBulletin folks are pretty smart.

droid101 10-15-2008 06:48 PM

Quote:

Originally Posted by noppid (Post 1645211)

Have you posted the specific error? The vBulletin folks are pretty smart.

I did and they mostly said it's the host's problem. The host said that the queries are too long and timing out. So back to the drawing board.


All times are GMT. The time now is 11:52 AM.

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.02371 seconds
  • Memory Usage 1,709KB
  • 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
  • (3)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