Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-09-2006, 07:35 PM
doozy doozy is offline
 
Join Date: Nov 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL Problems

Hello everyone.

My site is running very slowly and my hosting provider responded with the following message.


Quote:
Hello,

We have investigated that & it seems that your script is creating too many connection on mysql :
Please check the logs. This is causing to load your site slowly.


root@computersemidedicated [/home/dogpaw/public_html]# mysqladmin pr
+-----+---------------+-----------+---------------+---------+------+------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------------+-----------+---------------+---------+------+------------------+------------------+
| 59 | nybgroup | localhost | | Connect | 321 | Reading from net | |
| 66 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 110 | | |
| 67 | nybgroup | localhost | nybgroup_base | Sleep | 294 | | |
| 69 | nybgroup | localhost | nybgroup_base | Sleep | 293 | | |
| 75 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 84 | | |
| 83 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 188 | | |
| 84 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 186 | | |
| 88 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 161 | | |
| 89 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 145 | | |
| 91 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 142 | | |
| 92 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 140 | | |
| 93 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 128 | | |
| 94 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 125 | | |
| 95 | dogpaw_quincy | localhost | dogpaw_gpaw | Sleep | 114 | | |
Unfortunatly I don't know how to go about fixing this. My hosting provider has said they have restarted MySQL and that the site is fine. I had asked them to increase the max connection (which is currently set at 500) but they skirted the request. I also have my config.php file set to "0" for PERSISTENT CONNECTIONS.

I am getting the following errors sent to me by email:

Quote:
Database error in vBulletin 3.0.7:

Invalid SQL: SELECT value AS logtime FROM statistic_setting WHERE setting_for = 'logtime'
mysql error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

mysql error number: 2002
Quote:
Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0
Any help would be greatly appreciative.

Thanks
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:16 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.05616 seconds
  • Memory Usage 2,256KB
  • Queries Executed 12 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • 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_threaded
  • showthread_threaded_construct_link
  • 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