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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
