Bug #41016 | Maria: ALTER TABLE PACK_KEYS and MAX_ROWS has no effect | ||
---|---|---|---|
Submitted: | 25 Nov 2008 14:18 | Modified: | 13 Jan 2009 8:12 |
Reporter: | Guilhem Bichot | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Maria storage engine | Severity: | S3 (Non-critical) |
Version: | 5.1-maria | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[25 Nov 2008 14:18]
Guilhem Bichot
[13 Jan 2009 8:12]
Michael Widenius
This is not a bug. The reason that Maria file size is not changed is that for 2 indexes and a block size of 8K, 24576 is the smallest file size for the index file: - 1 block for for Maria header - 1 block for index 1 - 1 block for index 2 When running the test with a count of 500 (5000 rows) we get: Maria with transactional=0 @unpaked_keys_size @paked_keys_size 122880 57344 and with transactional= 1 @unpaked_keys_size @paked_keys_size 188416 57344 (Note that the packed values for transactional is a little too good as alter table removes the transid's from the index)