Work Around: Error SQL server exceeded max questions

[Zachariah]

Originally Posted by thinkfast

is this work for vbulletin 4?

Yes this should work the same.

[Alecsmith]

first of though this will make forum loading fast but after i adding more Mysql users but it made forum loading very slow

[Poker Face]

Originally Posted by Zachariah

Replace with:

PHP Code:

//***** MASTER DATABASE USERNAME & PASSWORD ******
//    This is the username and password you use to access MySQL.
//    These must be obtained through your webhost.
$dblogins = array();

$dblogins['1']['user'] = 'user1';
$dblogins['2']['user'] = 'user2';
$dblogins['3']['user'] = 'user3';
$dblogins['4']['user'] = 'user4';
$dblogins['5']['user'] = 'user5';
$dblogins['6']['user'] = 'user6';
$dblogins['7']['user'] = 'user7';

srand((float) microtime() * 10000000);
$dbloginid = array_rand($dblogins);
while ($dblogins[$dbloginid]['user'] == '')
{
    $dbloginid = array_rand($dblogins);
}
$config['MasterServer']['username'] = $dblogins[$dbloginid]['user'];

unset($dblogins, $dbloginid);

$config['MasterServer']['password'] = 'password'; 


1) Make sure and replace user1, user2, user3, user4, user5, user6, user7 with the correct user names made for the database.

2) Also replace password with the correct password.

This isn't working for some reason... where does the database name 'username' get inserted or replaced, as in the original instructions?

My Database: $config['Database']['dbtype'] = 'mysqli';

[combs]

This is genius. I didn't want to change servers and Hostgator can be a real pain in the ass. I did this and the forum was INSTANTLY faster and the hundreds of errors in my email have stopped(for now..let it continue). Thanks a ton man!

[Videx]

Originally Posted by combs

This is genius.

Only until they catch you. They've limited you to 25 connections per account, not per user (which would basically be unlimited connections).

[Zachery]

Some webhosts will ban you for this, find a REAL webhost.

[thincom2000]

Is there any other benefit from spreading the connections over multiple accounts (slight performance gain, maybe)? I just moved to a dedicated server, and am wondering if I even need this any more.

[Zachery]

Nope.

[SVTCobraLTD]

I am going to try this, hopefully it eliminates my errors:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/xxxxxxx/forums/includes/class_core.php on line 311

[Zachery]

SVT, it wont in your case, your mysql server has reached the GLOBAL limit, not your user limit.