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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:2.3.3 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D3 (Medium)

[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.