Bug #7883 myisam_data_pointer_size does not impact keyfile pointer size
Submitted: 13 Jan 2005 18:07 Modified: 15 Jul 2008 0:51
Reporter: Dean Ellis Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:4.1.10 OS:Any
Assigned to: CPU Architecture:Any

[13 Jan 2005 18:07] Dean Ellis
Description:
Setting myisam_data_pointer_size does not affect the keyfile pointer size, so you still have to use MAX_ROWS and AVG_ROW_LENGTH.

How to repeat:
SET GLOBAL myisam_data_pointer_size=8;

myisamchk -dvv or SHOW TABLE STATUS:

Datafile pointer (bytes):        8  Keyfile pointer (bytes):        2

Suggested fix:
Make the variable control both pointer sizes, or add another variable.
[15 Jul 2008 0:51] Trudy Pelzer
Won't be fixed in extended maintenance version.