MySQL Bugs: #22923: myisam_max_sort_file

Bug #22923	myisam_max_sort_file_size sizing
Submitted:	3 Oct 2006 8:55	Modified:	26 Oct 2006 17:50
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.0	OS:
Assigned to:	Paul DuBois	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
According to support team (domas) myisam_max_sort_file_size should be in optimal case bigger than the whole MYI file. This could IMHO be written more explicitly in the Doku Chap. 5.2.3. System Variables.
I need this for customers with indexes >> 2 GB.

How to repeat:
n.a.

Suggested fix:
Write it explicitly, that if index files are bigger than default (2 G) and enough space is available this value can be set higher to get sped.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.