Bug #339 myisam_max_sort_file_size and myisam_max_extra_sort_file can't be set high

Submitted: 28 Apr 2003 3:55 Modified: 13 May 2003 9:24
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.13 OS:Linux (Linux)
Assigned to: Jani Tolonen CPU Architecture:Any

[28 Apr 2003 3:55] Peter Zaitsev
Description:
Values for myisam_sort_file_size and myisam_extra_sort_file size can't
be set to above 4G at server startup:

mysql> show variables like "myisam%";
+---------------------------------+------------+
| Variable_name                   | Value      |
+---------------------------------+------------+
| myisam_max_extra_sort_file_size | 4294967295 |
| myisam_max_sort_file_size       | 4293918720 |
| myisam_recover_options          | OFF        |
| myisam_sort_buffer_size         | 134217728  |
+---------------------------------+------------+
4 rows in set (0.00 sec)

This is from server started with myisam_max_sort_file_size=100G
myisam_max_sort_file_size=100G

On other hand you can set them higher with SET option:
mysql> set myisam_max_sort_file_size=100000000000;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "myisam%";
+---------------------------------+--------------+
| Variable_name                   | Value        |
+---------------------------------+--------------+
| myisam_max_extra_sort_file_size | 4294967295   |
| myisam_max_sort_file_size       | 100000000000 |
| myisam_recover_options          | OFF          |
| myisam_sort_buffer_size         | 134217728    |
+---------------------------------+--------------+
4 rows in set (0.00 sec)

How to repeat:
start mysqld with myisam_max_sort_file_size more than 4G.
[13 May 2003 9:24] Michael Widenius
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.