Re: myisam_block_size set to 4K corrupts indexes

[Ingo Strüwing]

David Lombardi wrote:
...
> The very first attempt to insert a row in a table
> of mine (that has an auto-inc primary key, plus
> another two indexes) fails with 'cannot insert
> duplicate key...' (error 126) and afterwards the
> table indexes are corrupted.

Please report this as a bug on bugs.mysql.com.

> When the tables are created all report an index
> size of 4K, on the first insert attempt (that
> fails) the index file size jumps to 16K.

This looks correct if your table has three indexes. Each starts with a 4K block on its own.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com