Thread: Open Mysql connections

We installed AE 4.0 IQ and we have 1500 users. Usually there are 120 users online at the same time. But we've got major server problems. The site is verry often down. Users get the message couldn't connect database.
We've contacted our hosting company (xxxhostit.com) very often about this problem and they blame us. We have to many open connections to the database. When I check/test somethings local I see, when I'm logged in as a single user and I'm surving over the site, there are many connections to mysql server, the script didn't close the connections.

Is there anyone who has the same problem or is there anyone who has an solution for this major problem?

Hi,

Actually - this is a two sided problem. First - your hosting company should make sure they have the number of connections and other parameters set correctly for mySQL to support a high number of concurrent users.

Make a phpinfo.php file – so you can see for yourself how they have things configured.

As for the dating site, and db.inc.php - you may want to try a couple of things:

1) disable pconnect in db.inc.php, or if you can, with a php.ini override in either .htaccess or a local php.ini

2) take a look at the code (or lack of) where connections are explicitly closed - and modify that to do a better job of closing completed connections.

However - perhaps #1 is the first step.... search ModMySite for pconnect to find threads about this. Send me a PM if you would like us to help you with this.

Rob

Originally Posted by freexel

We installed AE 4.0 IQ and we have 1500 users. Usually there are 120 users online at the same time. But we've got major server problems. The site is verry often down. Users get the message couldn't connect database.
We've contacted our hosting company (xxxhostit.com) very often about this problem and they blame us. We have to many open connections to the database. When I check/test somethings local I see, when I'm logged in as a single user and I'm surving over the site, there are many connections to mysql server, the script didn't close the connections.

Is there anyone who has the same problem or is there anyone who has an solution for this major problem?

Rob,

I have sent you several pm's and an email regarding request for paid assistance over past number of days... no response. Are you getting my messages?

Originally Posted by dmatkov

Rob,

I have sent you several pm's and an email regarding request for paid assistance over past number of days... no response. Are you getting my messages?

I already informed Rob about this, Although his out of town this week Im sure he'll update you.

We've t this message from our hosting company:
| Id | User | Host | db | Command | Time | State | Info|
|9698 | *** | *** |***| Sleep | 32 | | NULL|

Can someone give us advise?