Bug #60991 Key Buffer Size advice for Windows is wrong

• Submitted: 28 Apr 2011 10:58
• Modified: 24 May 2011 17:05
• Reporter: Daniël van Eeden
• Status: Closed
• Category: MySQL Enterprise Monitor: Advisors/Rules
• Severity: S3 (Non-critical)
• Version: 2.3.3
• OS: Any
• CPU Architecture: Any

[28 Apr 2011 10:58] Daniël van Eeden

Description:
The "Key Buffer Size May Not Be Optimal For System RAM (v 1.6)" rule has an outdated advice for Windows.

"You cannot set the buffer > 4Gb on MySQL server versions prior to 5.0.52, or any Windows version"

But this is wat the manual says:
"As of MySQL 5.1.31, values larger than 4GB are also permitted for 64-bit Windows."
Source: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_key_buffer_size

How to repeat:
Read advice for the key buffer size rule.

Suggested fix:
Adjust advice.

Bug #60586 is for the same rule.

[28 Apr 2011 11:44] Valeriy Kravchuk

Thank you for the bug report.

[24 May 2011 17:05] John Russell

Added to 2.3.4 changelog:

The Key Buffer Size Greater Than 4 GB and Key Buffer Size May Not Be
Optimal For System RAM rules were updated to take in to account that
the key_buffer_size variable can now be set to greater than 4GB on
64-bit Windows systems.