Question about ajax coding.

[Dutch_Boy]

Hello,

I got a problem with my forum. So times the forum is really slow. The owner gets a database everytime when this appens.

Database error in vBulletin :

mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: Too many
connections
/home/sites/forum.highflow.nl/web/includes/class_core.php on line 313

MySQL Error :
Error Number :
Request Date : Tuesday, August 10th 2010 @ 12:38:21 PM
Error Date : Tuesday, August 10th 2010 @ 12:38:21 PM
Script : http://forum.highflow.nl/ajax.php
Referrer : http://forum.highflow.nl/
IP Address : ****
Username :
Classname : vB_Database
MySQL Version :

He thinks it got something to do with our shoutbox. Our forum gets realy slow when there are around 40/50 people on the forum. He thinks it got something to do with the shoutbox because allot of people asking thinks from the database for the shoutbox.

Kind regards,

Dutch_Boy.

 

[Deceptor]

Hey dutch_boy,

You can optimise the shoutbox by enabling the File System cache, this way it'll only use AJAX/DB connections when there's something to get, so it's highly recommended. As for the MySQL error itself, it can be prevented by increasing your maximum MySQL connections, do you know what they are right now? Typically it should be around 300-ish.

 

[Dutch_Boy]

Done, hope this will help. And no i dont know the max MySQL connections.

Ill check that out. Maybe we can turn it up a little.

Edit:

Check the class_core.php file and this is on line 313 ( with dreamweaver)

$link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);

 

[Dutch_Boy]

We increased the number of MYSQL to 250. But they didnt say how high it was before.

I hope this will fix our problem.