Bug #68960 Wrong default value of max_connections server system variable

• Submitted: 15 Apr 2013 8:34
• Modified: 13 Aug 2015 23:59
• Reporter: Roman Syroeshko
• Status: Closed
• Category: MySQL for Windows: Installer
• Severity: S3 (Non-critical)
• Version: 5.6.10
• OS: Windows (Windows 7)
• CPU Architecture: Any
• Tags: max_connections

[15 Apr 2013 8:34] Roman Syroeshko

Description:
The default value of max_connections server system variable set during installation doesn't equal the default value of this system variable mentioned in MySQL Reference.

How to repeat:
1. Open the link (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_connections) and make sure that default value of the max_connections variable is defined as "151" there.
2. Open the link (http://dev.mysql.com/doc/refman/5.6/en/too-many-connections.html) and make sure that default value of the max_connections variable is defined as "151" there to.
3. Download MySQL INstaller 5.6.10 and run it.
4. Choose "Server Machine" option in "Config Type" field during the "Configuration" installation step.
5. Look into "my.ini" (C:\ProgramData\MySQL\MySQL Server 5.6) after the installation is finished and make sure that value of the max_connections variable is set to "100" there.
6. The values received in Steps 1 and 2 doesn't equal the value received in Step 5 ("151" vs. "100").

Suggested fix:
Set max_connections default value equal to "151" in my.ini.

[15 Apr 2013 11:19] MySQL Verification Team

Hello Roman,

Thank you for the report.
Verified as described.

Thanks,
Umesh

[13 Aug 2015 23:59] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.4.10 release, and here's the changelog entry:

The default max_connection variable was changed from 100 to 151 for MySQL
server 5.6 and above. The value is still set to 100 for MySQL server 5.5
and below.

Thank you for the bug report.