MySQL max concurrent connections

[ToneZ0r]

Could I just ask a very naive question?

In the following code:

PHP Code:

// Define array of username/password combo's
$my_sql_configs = array(
  0 => array('user' => 'user1', 'pass' => 'pass1')
 , 1 => array('user' => 'user2', 'pass' => 'pass2')
 );
// Randomly select 1
$selecteduser = array_rand($my_sql_configs);
// Assign selected user to config
$config['MasterServer']['username'] = $my_sql_configs[$selecteduser]['user'];
$config['MasterServer']['password'] = $my_sql_configs[$selecteduser]['pass']; 


.. should I be changing any of these values, such as 'user', 'username' and 'password' - or leaving the code exactly as it is written here on the thread?

Also, exactly where in the config.php code should I be inserting this?

I have pasted the code Marco has written exactly 'as is', and placed it in the config.php file, directly above:

PHP Code:

//    ****** DATABASE TYPE ******
//    This is the type of the database server on which your vBulletin database will be located. 


I am still getting the max_questions error when trying to import my phpbb2 board with Impex to VB 3.6.2. It's 100MB and is knocking the database out frequently when the max_questions limit kicks in.

Many Thanks

[Dismounted]

The "max_questions" error is different from the "max_concurrent_connections" error. Your error (max_questions) cannot be solved unless you modify the variable itself.

[Marco van Herwaarden]

Not true Dismounted, the max_questions is also counted per MySQL user in most cases.

@ToneZ0r
You should replace the 'user1' & 'pass1' (and 2, duplicate if more lines needed) with the real MySQL username/passwords you have created.

You should place the code directly under:

PHP Code:

 // ****** MASTER DATABASE USERNAME & PASSWORD ******
 // This is the username and password you use to access MySQL.
 // These must be obtained through your webhost.
$config['MasterServer']['username'] = 'xxxx';
$config['MasterServer']['password'] = 'xxxx'; 


[Dismounted]

Thanks for the correction, Marco. I've always thought max_questions to be counted overall, but I may be confusing things with myself. MySQL isn't my forte either .

[SVTCobraLTD]

So since MrEyes switched hosting companies, I guess this is not going to be known if it will work? My current company has a limit of 25 connections.