Bug #25853 key_cache_block_size=4MB causes table corruptions + duplicate key errors
Submitted: 25 Jan 2007 16:20 Modified: 20 Jun 2007 1:01
Reporter: Edmond Hui Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:5.0.27,5.0.40BK, 5.1.18BK OS:Linux (Linux Fedora Core 5)
Assigned to: Ingo Strüwing CPU Architecture:Any
Tags: corruption, key_cache_block_size, myisam

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[10 Apr 2007 14:24] Shane Bester
start mysqld with --key_cache_block_size=4M, import this file, run check table t1

Attachment: bug25853_testcase.sql (application/octet-stream, text), 86.22 KiB.