My host is saying dump SMF- Help!!

[BPDFamily.com]

Does anyone know where I can get a VPS Host with more max_user_connections limit than SITE5.

I like SMC and want to stay with it.


SITE5.COM ANSWER 1: From the detail provided, it sounds likely that your board is hitting a max_user_connections limit, however we cannot be certain without more detail from the original error. If this is the case, Vince's suggestion would in line with using a script that manages SQL connections in a more efficient manner, or alternatively using a server such as dedicated of VPS that would simply allow more simultaneous user connections.


SITE5.COM ANSWER 2: The max_connections_limit is a value set to limit the amount of queries each account can run.  It is put in place to maintain performance on the server so one user cannot run hundreds of MySQL queries.

All of our shared hosting accounts have the same limits on the MySQL connections, so you cannot purchase more of them.  I would also highly recommend that you switch to a different forum.  Vbulletin has been around for a while and it runs most of the largest forums on the internet.  It should be able to better manage the MySQL connections and prevent you from maxing out your connections.


Details of this Errors I'm receiving: http://www.simplemachines.org/community/index.php?topic=172878.msg1102559#msg1102559

[metallica48423]

firstly...

S M F
Simple Machines Forum
 

anyhow, check out our Hosts and Hosting board as there are a good number of hosts there both in review and in offering services.

[Simplemachines Cowboy]

I use Site5 and they have been great.
Maybe once a week or less I have a momentary (never lasted more than 30 seconds) failure to connect to the database, but that's it.

My stats:
Av posts per day: 150
Av online per day: 193
Total members: 2475
Av. page views per day: 23277
Total posts: 68597
Most online: 304
Total page views: 2959934

[babjusi]

Have a look here Facing the facts.  http://www.whathostingshouldbe.com/

They have some great packages deal there, I bought one myself a couple of days ago. And the support and service those guys provide there, is the best.

[BPDFamily.com]

My stats:
Av posts per day: 150
Av online per day: 193
Total members: 2475
Av. page views per day: 23277
Total posts: 68597
Most online: 304
Total page views: 2959934

Thanks for posting these STATs.  We're about 2x your size... we have 1,600 - 2,000 visitors a day.  The problem really does't surface until we hit 1,800

[SleePy]

Is this issue solved or do you still require assistant?

Are you using the latest version of SMF?
Any Mods installed?
Are you using a custom theme?

It is possible that their php is not setup correctly and closing mysql connections when it is done.
In this case you might need to tweak index.php (As I doubt they will fix their setup) and add some php functions that should close the mysql connectio just before it is done (Though php should auto do it when it is finished with the script).

[BPDFamily.com]

Are you using the latest version of SMF? = 1.1.2
Any Mods installed?  = advertsing
Are you using a custom theme? = Default


"In this case you might need to tweak index.php (As I doubt they will fix their setup) and add some php functions that should close the mysql connectio just before it is done (Though php should auto do it when it is finished with the script)."

Any instructions on this?

Thanks... this is really annoying.

[endgame]

As far as free hosting, you can beat freehostia, but according to what you're saying, you  may need to pay for a host.

[SleePy]

Open index.php and Find:

Code Select Expand

// Call obExit specially; we're coming from the main area ;).
obExit(null, null, true);

Add Before that

Code Select Expand

// Close the current connection
mysql_close($db_connection);

[BPDFamily.com]

Tried the script change and got this?  Thoughts?


Warning: mysql_query(): 8 is not a valid MySQL-Link resource in /home/facingth/public_html/Sources/Subs.php on line 321
2: mysql_query(): 8 is not a valid MySQL-Link resource
File: /home/facingth/public_html/Sources/Subs.php
Line: 321




// What function shall we execute? (done like this for memory's sake.)
call_user_func(smf_main());

// Close the current connection
mysql_close($db_connection);

// Call obExit specially; we're coming from the main area .
obExit(null, null, true);

// The main controlling function.
function smf_main()

[SleePy]

That is odd it shouldn't do that

Ok,
Move:

Code Select Expand

// Close the current connection
mysql_close($db_connection);
All the way to the bottom just before the

Code Select Expand

?>

[BPDFamily.com]

I greatly appreciate the help here.  I do think the terminations are the issue. 

This last fix caused some problems.  I didn't see it, but I implemented it aat 2 AM and this is the feedback I received in the morning from 2 members...

Where can we go from here?

---------------------------------------


RE Technical issue
« on: Today at 05:05:31 AM »
Hi guys,

I seem to be having trouble with navigating the board, it seems to be constantly refreshing and most the time everything is showing up in code rather than the images etc. I don't know if it's just me and I'm doing something wrong, as I am a technophobe lol....

All feedback greatly appreciated, but it may take me a while to be able to read it 

Bish x

[SleePy]

The last fix shouldn't of caused any refresh issues.
It should of been closing the open mysql connection.

It may be time to start looking a new host. We have a Hosts and Hosting board here that may help with this

[metallica48423]

perhaps a link would help

Hosts and Hosting

[BPDFamily.com]

perhaps a link would help

Perhaps!

I'm sorry should have put this up much earlier - thanks.


http://www.facing-the-facts.net/

[SleePy]

Can you post your my.cnf and your php.ini settings? This is your mysql and php setup.

I will move this board to performance and server configuration. But this is coming down to a server configuration issue. Maybe someone who knows enough of this can spot something in the configs that should be changed.

Your site is about a medium site as well. So VPS is good for you for a while.