Can't reach site, get fatal error message. why?

Live forum: http://forum.freeipodguide.com/viewtopic.php?t=51261

phriq

11-01-2007 13:04:36

alot of times when trying to reach this site i get this message

Warning mysql_connect() [function.mysql-connect] User 'bosbos' has exceeded the 'max_user_connections' resource (current value 25) in /home/virtual/site211/fst/var/www/html/db/mysql4.php on line 63

Fatal error Call to a member function on a non-object in /home/virtual/site211/fst/var/www/html/includes/functions.php on line 1121

does anyone know why?
thanks

TFOAF

11-01-2007 13:20:19

Because the server can only handle a certain number of connections. If there are too many users browsing FiPG, it goes down until the the amount of users connected drops down below the limit.

Twon

11-01-2007 16:43:27

grrrr.... this is annoying...

johnjimjones

11-01-2007 17:23:27

yeah it happened for most of the day for me....

Twon

11-01-2007 18:26:40

Is it being addressed by at all???

dmorris68

11-01-2007 20:12:04

It isn't something WE can easily address. There are limited connection resources available at the current datacenter. After the datacenter move happens, hopefully things will lighten up.

I have to pour through the code at some point to see if I can optimize some SQL to perhaps reduce the number of times we hit the DB, but it's going to be awhile before I can spend much time on it. I just went back to work after 3 weeks off and I'm totally swamped at the moment.

cheeseball01

12-01-2007 00:44:16

[quotee794470cd9="dmorris68"]It isn't something WE can easily address. There are limited connection resources available at the current datacenter. After the datacenter move happens, hopefully things will lighten up.

I have to pour through the code at some point to see if I can optimize some SQL to perhaps reduce the number of times we hit the DB, but it's going to be awhile before I can spend much time on it. I just went back to work after 3 weeks off and I'm totally swamped at the moment.[/quotee794470cd9]

Do you access your SQL through MyPHP admin? If so, it's an easy button click to optimize your databases

compuguru

12-01-2007 05:26:59

[quote58ddb9c365="cheeseball01"][quote58ddb9c365="dmorris68"]It isn't something WE can easily address. There are limited connection resources available at the current datacenter. After the datacenter move happens, hopefully things will lighten up.

I have to pour through the code at some point to see if I can optimize some SQL to perhaps reduce the number of times we hit the DB, but it's going to be awhile before I can spend much time on it. I just went back to work after 3 weeks off and I'm totally swamped at the moment.[/quote58ddb9c365]

Do you access your SQL through MyPHP admin? If so, it's an easy button click to optimize your databases[/quote58ddb9c365]
I don't think it's the databases that are the problem. It's the code that queries the databases that is creating the issue.

CollidgeGraduit

12-01-2007 05:46:46

Guys, no offense, but something as easy as a button click wouldn't have escaped dmorris.

Plus, he mentioned nothing about optimizing the databases. He said he needs to optimize the code to minimize the number of hits we make on the database.