I posted a detailed description of a similar problem one week ago to general and then later to internals with no response to either (title "load index into cache doesn't?").
Using load index into cache to preload a 1GB index into a 2GB cache comes back in 0.0 seconds as 'done'. But there is no disk IO (it should take 10-30 seconds to load 1GB from disk), and no impact in query speed. As Mark says - isn't that the point of preloading? Also if I could 'me too' on getting individual indexes loaded. For big tables with multiple indexes where it's only possible to fit one or two in the cache, having to load the entire set of indexes really kills the usefulness of this otherwise brilliant feature. I've resorted to creating a HEAP (Btree) 'summary' table with only the indexes I need in the meantime. Best, Andrew. --- Mark Maunder <[EMAIL PROTECTED]> wrote: > This bug is a problem with the reporting when > sending a SIGHUP or the > command mysqladmin debug. What I'm seeing is the > process simply isn't > growing in memory. I'm looking at the process size > in 'top'. > > I do notice that it grows once I start hitting it > with queries. I'd > expect it to grow as soon as I preload the index. > Isn't that the point > of preloading? > > On Fri, 2004-11-05 at 05:25, Gleb Paharenko wrote: > > Hi. > > > > There is a bug: > http://bugs.mysql.com/bug.php?id=4285. > > > > > > > > Mark Maunder <[EMAIL PROTECTED]> wrote: > > > I have a large fulltext index (the MYI file is > about 750 Megs) and I've > > > set my key_buffer_size to 1 Gig. I do: > > > load index into cache fttest; > > > and I watch the Mysql process in memory, and it > doesn't grow. It just > > > hangs around 250Megs. Why isn't the index > loading into memory? > > > > > > Thanks, > > > > > > Mark. > > > > > > > > > > > > -- > > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > > This email is sponsored by Ensita.NET > http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / > Ensita.NET > > <___/ www.mysql.com > > > -- > Mark D. Maunder <[EMAIL PROTECTED]> > http://www.workzoo.com/ > "The Best jobs from the Best Job Sites." > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
