Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.13
-
CentOS 6.9 & CentOS 7.3
Description
myisamchk fails with the following error:
/bin/myisamchk: Unexpected end-of-file found when reading file '/STMWKoK5' (Errcode: 175 "File too short; Expected more data in file").
|
when rowcount exceeds 2.124 billion and key_buffer_size and sort_buffer_size under [myisamchk] tag is set to 4GB.
When these values are adjusted to 2GB, the command works.
As the table has grown to ~3 billion rows, buffer sizes must be lowered to 1GB for the command to work.