Thanks! One question though - in the Index Preloading section, it says: "If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its non-leaf nodes...".
How can I determine the number of blocks in an index, or the number of blocks for the non-leaf nodes? Is there anything that will help me determine these values? Thanks! Eric "Paul DuBois" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At 13:35 -0500 2/23/04, Eric B. wrote: > >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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
