OK, thanks. I've reported this as a bug, and another, below. I must admit, this production release seems flakey: http://bugs.mysql.com/bug.php?id=6447
On Fri, 2004-11-05 at 04:03, Haitao Jiang wrote: > Mark > > It is a known problem with this feature. So far I am not aware of any > solution to it. Just want to let you know that you are not alone > having this problem. > > Haitao > > > On Fri, 05 Nov 2004 02:16:49 +0000, Mark Maunder <[EMAIL PROTECTED]> wrote: > > I keep getting this error when trying to preload a fulltext index. I've > > checked the block size of the fulltext index using myisamchk (is there > > an easier way to find out block size?) and it is 2048. The block size of > > the primary key on the same table is 1024. Is that what it means by > > "Indexes use different block sizes"? > > > > As you can see from below, I've tried to only load the fulltext index, > > and the error persists. I have also tried setting the global > > key_cache_block_size to 2048 and that didn't work. I have also tried > > creating a separate key cache with it's own 2048 block size and > > preloading the index into that, and that didn't work either. > > > > Any help is appreciated. > > > > mysql> load index into cache fttest INDEX (ft); > > +----------------+--------------+----------+-----------------------------------+ > > | Table | Op | Msg_type | > > Msg_text | > > +----------------+--------------+----------+-----------------------------------+ > > | workzoo.fttest | preload_keys | error | Indexes use different block > > sizes | > > | workzoo.fttest | preload_keys | status | Operation > > failed | > > +----------------+--------------+----------+-----------------------------------+ > > 2 rows in set (0.00 sec) > > > > Mark. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- 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]