Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Currently buildbot only runs the InnoDB tests with the default innodb_page_size=16k.
We have 3 classes of test failures when running with non-default page size:
- Result differences (for example, different statistics)
- Failing operations (for example, too large KEY_BLOCK_SIZE, or attempt to use ROW_FORMAT=COMPRESSED with innodb_page_size larger than 16k)
- Bugs revealed by the tests: for example,
MDEV-11828was revealed by running innodb.innodb-64k.
I did two test runs on 10.2 to see how many tests are affected. Not that many:
./mtr --parallel=auto --force --retry=0 --max-test-fail=0 --suite=innodb,innodb_fts,innodb_gis,encryption --mysqld=--innodb-page-size=64k --mysqld=innodb-buffer-pool-size=24M;
|
./mtr --parallel=auto --force --retry=0 --max-test-fail=0 --suite=innodb,innodb_fts,innodb_gis,encryption,innodb_zip --mysqld=--innodb-page-size=4k
|
There could be some more failures with 8k or 32k, but I thought that it would be better to look at the extremes first:
encryption.innodb_encryption_tables innodb.innodb-64k encryption.innodb-log-encrypt encryption.innodb-page_encryption_log_encryption encryption.innodb_encryption_row_compressed innodb.innodb_uninstall innodb_zip.innodb_cmp_drop_table encryption.innochecksum encryption.innodb-discard-import encryption.create_or_replace innodb.innodb_defragment encryption.innodb-page_encryption encryption.innodb_encryption_discard_import encryption.innodb_page_encryption_key_change innodb.innodb_defrag_stats encryption.innodb_onlinealter_encryption innodb.innodb_simulate_comp_failures_small innodb_zip.innodb_bug36169 innodb.binlog_consistent innodb.innodb_defrag_concurrent innodb.innodb_simulate_comp_failures innodb.innodb_trx_weight innodb.innodb-page_compression_zip innodb.innodb-wl5522-debug innodb.temporary_table innodb.strict_mode innodb_zip.innodb_bug53591 innodb_zip.innodb-zip innodb_fts.innodb_fts_misc_1 innodb_zip.innodb_bug56680 innodb_zip.innodb_bug36172 innodb_zip.innodb_bug52745 innodb.innodb_defrag_binlog
innodb.innodb_mysql innodb.innodb_uninstall innodb_zip.innodb_cmp_drop_table innodb.innodb_defrag_concurrent innodb.innodb_defrag_stats innodb.innodb_simulate_comp_failures_small encryption.innodb_lotoftables innodb.innodb_defrag_stats_many_tables innodb.binlog_consistent innodb.innodb_simulate_comp_failures innodb.innodb_trx_weight innodb.innodb-change-buffer-recovery innodb_zip.4k innodb.innodb-page_compression_zip innodb.innodb-wl5522-debug innodb.innodb_prefix_index_restart_server innodb_zip.wl6501_crash_4 innodb.strict_mode innodb_zip.index_large_prefix_4k innodb.innodb_defrag_binlog innodb_gis.rt_precise
Attachments
Issue Links
- relates to
-
MDEV-13013 InnoDB unnecessarily extends data files
-
- Closed
-
-
-
- Closed
-