Thanks Victoria! I must have missed that option. Exactly what I was looking for!
Eric "Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Eric B." <[EMAIL PROTECTED]> wrote: > > 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? > > What about --init-file option of mysqld? > http://www.mysql.com/doc/en/Server_options.html > > > > > 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? > > No, you can't. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]