Re: Pre-loading index file

2004-02-25 Thread Victoria Reznichenko
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

Re: Pre-loading index file

2004-02-25 Thread Eric B.
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

Pre-loading index file

2004-02-24 Thread Eric B.
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