Bug #17909 default index location variable
Submitted: 3 Mar 2006 22:43 Modified: 5 Mar 2006 8:45
Reporter: Rob Blick Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:5.0.18 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[3 Mar 2006 22:43] Rob Blick
I suggest adding a server parameter, maybe "MyISAM_index_directory" that specifies a default path for the .MYI files.  I like to place my .MYI and .MYD files on separate filesystems for performance, and it would be nice if the .MYI files were automatically created in the correct location when the tables were created.  Users seldom know what filesystems and directories are located on the MySQL server; they just want to issue a "CREATE TABLE" statement and get on with their work.  By adding a server parameter such as this (which could be embedded in the my.cnf file), users could create tables without having to know where to place their index files (i.e., they wouldn't need to give the INDEX DIRECTORY table option).  

How to repeat:
N/A - feature request

Suggested fix:
Add a server parameter specifying the default .MYI creation path.  Ideally, this parameter would specify an index base path, and each .MYI file would get created in MyISAM_index_directory/DatabaseName/.  For example, if the MyISAM_index_directory is '/raid0/index/', a table called 'tableA' in the 'test' database would have its .MYI file at /raid0/index/test/tableA.MYI.
[5 Mar 2006 8:45] Valeriy Kravchuk
Thank you for a reasonable feature request. 

Do not expect it be implemented really soon, though. As well as, please, do not expect a huge performance increase in general just because of indexes are put on a separate device.