Bug #34324 unknown variable 'myisam_max_extra_sort_file_size=100G'

Submitted: 5 Feb 2008 18:50 Modified: 11 Feb 2008 9:21
Reporter: Sloan Childers Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Maria storage engine Severity:S1 (Critical)
Version: OS:Any
Assigned to: Michael Widenius CPU Architecture:Any

[5 Feb 2008 18:50] Sloan Childers
Description:
I'm working on Merlin scalability and I am currently testing myisam, falcon and trying to get started with maria.  

I installed mysql-5.1.23-maria-alpha-pb292-win32 today and copied the my-medium.ini to my.ini for configuration.

I added basedir and datadir to the my.ini as well as changing the port to 5307:

basedir="c:/dev/mysql-5.1.23-maria-alpha-pb292-win32/"
datadir="c:/dev/mysql-5.1.23-maria-alpha-pb292-win32/data"

When I try to start the engine I get the following error:

080205 12:30:05 [ERROR] bin\mysqld: unknown variable 'myisam_max_extra_sort_file
_size=100G'
080205 12:30:05 [ERROR] Aborting

080205 12:30:05  InnoDB: Starting shutdown...
080205 12:30:08  InnoDB: Shutdown completed; log sequence number 0 46409
080205 12:30:08 [Note] bin\mysqld: Shutdown complete

I tried to add that variable to the my.ini file

How to repeat:
Not sure.

Suggested fix:
If the variable doesn't exist take a smart default?
[5 Feb 2008 18:59] Paul DuBois
myisam_max_extra_sort_file_size no longer exists. From 5.0 manual:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html:

myisam_max_extra_sort_file_size (DEPRECATED)

This variable is not used. It was removed in MySQL 5.0.6.

So it doesn't exist in 5.1.
[11 Feb 2008 9:21] Guilhem Bichot
Hi Sloan, I think Paul's answer explains it all. Please re-open if not acceptable.

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

Page generated in 0.061 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.