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
• Status: Closed
• Category: MySQL Server: Maria storage engine
• Severity: S1 (Critical)
• 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.