vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Server issues? (https://vborg.vbsupport.ru/showthread.php?t=315117)

Peter Cook 10-29-2014 08:14 AM

Server issues?
 
Not sure if this is the right place, but, our website has been having extremely slow loading times and sometimes being reported database errors! below are a couple of reported errors.

example 1:
Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '62.4.27.91'
AND idhash = '64519265b60532704e960889f9c10763'
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006

example 2:

mysql_connect(): User lswukcouk already has more than 'max_user_connections' active connections
/hermes/waloraweb044/b1061/moo.lswukcouk/includes/class_core.php on line 317

MySQL Error :
Error Number :

Can anyone help with this as the hosting company says it's loading fine at their end.

thanks all.

ForceHSS 10-29-2014 08:24 AM

The first one is a hosting problem
the 2nd one tell your hosts to change max connections in the php.ini file
either way your hosts need to fix the problems

Peter Cook 10-30-2014 08:29 AM

I had a feeling that was the issue but according to them there are no problems!

ForceHSS 10-30-2014 09:20 AM

the 2nd one you could fix yourself but only if you have access to where the php.ini is stored

RichieBoy67 10-30-2014 04:08 PM

Quote:

Originally Posted by Peter Cook (Post 2520596)
I had a feeling that was the issue but according to them there are no problems!

If you are on a shared host then they are most likely limiting your resource usage. You need to try to lessen those query connections or upgrade to a bigger hosting package.

if you are on a dedi then adjust php.ini max connections as Force mentioned.

Peter Cook 11-01-2014 01:54 PM

My package is unlimited but the sql server is shared, the hosting company said they have had instances of large corperates taking up all the resources unneccessarily and are in touch with them which I thought strange.

RichieBoy67 11-01-2014 04:56 PM

Yeah, they say unlimited but you are sharing with who knows how many other websites. There are probably some ways you can reduce those connections though. Do they happen at a certain time of day? many times these happen when running back ups, sitemap generation, mass email, etc. if that is the case adjust your cron task times to make those processes run at slower times.

There are also some good threads here on reducing server load. Look them up and follow the advice and it may help you with this. I do not see your host being particularly helpful.


All times are GMT. The time now is 08:41 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.01071 seconds
  • Memory Usage 1,720KB
  • 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
  • (7)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