Hi,
I know this question has been posed in the past, but I haven't been able to find an answer for it yet.
Is there any way in MySQL to pre-load a table's index file into the key cache at startup?
Yes, this is something that was implemented recently:
http://www.mysql.com/doc/en/MyISAM_key_cache.html
I know the key cache will build itself while exectuing queries, but this will obviously slow down the first query that would otherwise be using the index. Short of manually executing all the possible queries (not a realistic option) before the system is enabled, does MySQL offer a start-up option that would pre-load the index table into its key cache such that the first queries do not suffer from the index loading?
Of course, I realize that the key cache memory would need to be large enough to handle such a table.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]