Hello.
Please send us output of the following statements: SHOW CREATE TABLE your_table; SHOW VARIABLES; SHOW STATUS; What output does the following command produce: myisamchk -d -v your_table HMax <[EMAIL PROTECTED]> wrote: > Hello there, > > We have a problem with the LOAD INDEX INTO CACHE command which is > supposed to be fixed in version 4.1.10 > > It may be fixed, but then we don't get the way to make it work. > > We want to load all the indexes of one of our big table into the main key > cache. > This table is myISAM, and has all sort of indexes, including UNIQUE > AND FULLTEXT. > > When we try to load the indexes into cache, we have the following error : > "Indexes use different block size" "Operation Failed" > > Now we created a small test table with 2 rows : > A integer, primary key, and a varchar(100) filled 10 times with MD5 > values of NOW(). > When the varchar row is not indexed, the command works fine, but when > we index it, LOAD INDEX INTO CACHE returns the same error. This means > this is not the FULLTEXT which create the problem. > > Key buffer block size is set to 1024. > Tried to change it to 2048 but won't do. > > Any help would be greatly appreciated. > Otherwise, I'll post a bug report. > > Thank you > -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
