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]
