An unexpected database error occurred. Please try again later.

[cdub]

I'm getting this error on my server:

An unexpected database error occurred. Please try again later.

<!-- Too many connections -->

When I view source I get the above? Know what's causing this?

http://www.studentfilms.com/index.php

I'm going to contact my host to see if they can restart a service for me.

 

[Paul B]

Are you on shared hosting?
There are probably limits in place.

 

[cdub]

And it's back online. Strange.

 

[cdub]

I submitted a ticket to hostgator - yes I'm on shared hosting.

 

[Paul B]

Most likely a surge in visitors caused you to breach the limits imposed by the host.

 

[Jake Bunce]

More information about the error here:

https://dev.mysql.com/doc/refman/4.1/en/too-many-connections.html

It's a limit in MySQL. On a shared server you have no control over this.

 

[cdub]

Hmmm... I'll have to check on how often it's happening to see if and when I need to upgrade servers. Thanks for all your help guys. XenForo support rocks!

 

[PeteUK]

We've had this happen twice and the forum is still in pre-release testing with only 100 members. So if it's a real issue then goodness knows what will happen when we go live.

Is it possible that connections could 'leak' rather like memory did under Windows XP, ie they aren't being closed down when they should be? Or do they eventually time-out and close themselves down?

The only add-on we're currently using is Post Ratings - taking likes to the next level. I use Navicat to run queries. We're on a shared server (Fasthosts), so no hope of changing the settings.

Any thoughts?

 

[Paul B]

This is a typical problem with shared hosting.

You will need to upgrade to a better package/server, be that shared, VPS or dedicated.

Or try a different host.

 

[PeteUK]

This is a typical problem with shared hosting.

You will need to upgrade to a better package/server, be that shared, VPS or dedicated.

Or try a different host.

Thanks - how do I know how many MySQL connections will be sufficient? When we go live we could easily have 50 times as many people on the site at any one time as we do at the moment - does that mean that if we currently have 100 connections we will need 5000?

A trial-and-error solution could be costly, time-consuming, and damaging for the reputation of the forum.

 

[Paul B]

This is the best place to ask about hosts and servers: http://xenforo.com/community/forums/server-configuration-and-hosting.48/

 

[PeteUK]

This is the best place to ask about hosts and servers: http://xenforo.com/community/forums/server-configuration-and-hosting.48/

Thanks, will do - although I'm not yet convinced that the problem is with the server configuration.

 

[Paul B]

With shared hosting, you will be pushing the limits at 100+ active members, never mind 50 times that.

 

[Zap-Robo @ WSC]

I submitted a ticket to hostgator - yes I'm on shared hosting.

My site is currently on HostGator Shared Hosting (until Friday when I dump them) and we're hitting a hard limit (25) on running processes which is what is giving us our current performance issues. Just in case that helps you (you can see the processes count on the HG cPanel down the left-hand column).

 

[cdub]

Yeah - I just checked - I'm certainly not at that point yet. Have you thought to switching to their VPS?

 

[Zap-Robo @ WSC]

Yeah - I just checked - I'm certainly not at that point yet. Have you thought to switching to their VPS?

No, their VPS seems a little costly for my tastes - I'm moving to Dreamhost (where I have other sites) and using their VPS offering if I need to (DH limit their shared hosting by memory used, and not processes).