Re: load index into cache not working

2004-11-08 Thread Andrew Clemente
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 di

Re: load index into cache not working

2004-11-05 Thread Mark Maunder
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

Re: load index into cache not working

2004-11-05 Thread Gleb Paharenko
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 memo