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.
grrrr.... this is annoying...
johnjimjones
11-01-2007 17:23:27
yeah it happened for most of the day for me....
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.