I know that in 4.11+ you can preload your MYI index file into the key cache using LOAD INDEX (http://www.mysql.com/doc/en/Index_preloading.html), but is there a way to configure MySQL to do this whenever the MySQL service starts? I'm willing to write .sql batch statements, but is there someway to configure the ini or the cnf file to execute a sequence of .sql statements upon startup?
Secondly, is there any way to determine the amount of space an entire index takes? Or how much space the non-leaf nodes in the index takes? Thanks, Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]