Bug #74463 Inaccurate default value for myisam_max_sort_file_size in the text
Submitted: 20 Oct 2014 19:42 Modified: 24 Oct 2014 16:40
Reporter: Grigory Rubtsov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0-5.7 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[20 Oct 2014 19:42] Grigory Rubtsov
Description:
The documentation at
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_myisam_max_sort...

states:
"The default value is 2GB."

In fact, as shown in the table above the text, the default value is 2Gb for 32-bit systems and 9 Eb for 64-bit systems. As the most of the systems are 64bit, 2Gb in the text is misleading.

How to repeat:
mysql> show variables like 'myisam_max_sort_file_size';
+---------------------------+---------------------+
| Variable_name             | Value               |
+---------------------------+---------------------+
| myisam_max_sort_file_size | 9223372036853727232 |
+---------------------------+---------------------+
1 row in set (0.02 sec)

Suggested fix:
Include both values or remove default from the text while keeping in the table.
[21 Oct 2014 4:38] MySQL Verification Team
Hello Grigory Rubtsov,

Thank you for the report.

Thanks,
Umesh
[24 Oct 2014 16:40] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

I'll remove the default from the text and let the table speak for itself.