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.