Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2, 10.3, 10.4
-
None
Description
innodb_zip.cmp_per_index 'innodb' [ fail ]
|
Test ended at 2019-10-04 16:46:28
|
|
|
CURRENT_TEST: innodb_zip.cmp_per_index
|
--- /home/kevg/work/m/bb-10.2-kevgs/mysql-test/suite/innodb_zip/r/cmp_per_index.result 2019-10-03 17:34:38.626389892 +0300
|
+++ /home/kevg/work/m/bb-10.2-kevgs/mysql-test/suite/innodb_zip/r/cmp_per_index.reject 2019-10-04 16:46:28.612642509 +0300
|
@@ -61,14 +61,14 @@
|
database_name test
|
table_name t
|
index_name b
|
-compress_ops 43
|
-compress_ops_ok 43
|
+compress_ops 42
|
+compress_ops_ok 42
|
uncompress_ops 0
|
database_name test
|
table_name t
|
index_name PRIMARY
|
-compress_ops 65
|
-compress_ops_ok 65
|
+compress_ops 45
|
+compress_ops_ok 45
|
uncompress_ops 0
|
SHOW CREATE TABLE t;
|
Table t
|
@@ -97,6 +97,6 @@
|
index_name PRIMARY
|
compress_ops 0
|
compress_ops_ok 0
|
-uncompress_ops 4
|
+uncompress_ops 2
|
DROP TABLE t;
|
SET GLOBAL innodb_cmp_per_index_enabled=default;
|
In a more recent branches also innodb.index_merge_threshold is broken in a similar manner:
--- /home/kevg/work/m/bb-10.3-MDEV-19783-check-table/mysql-test/suite/innodb/r/index_merge_threshold.result 2019-10-03 13:32:31.117762090 +0300
|
+++ /home/kevg/work/m/bb-10.3-MDEV-19783-check-table/mysql-test/suite/innodb/r/index_merge_threshold.reject 2019-10-04 13:03:11.654942019 +0300
|
@@ -1242,9 +1242,10 @@
|
and PAGE_TYPE = "INDEX" order by PAGE_NUMBER, NUMBER_RECORDS;
|
PAGE_NUMBER NUMBER_RECORDS
|
3 42
|
-4 2
|
+4 3
|
27 21
|
-28 21
|
+28 10
|
+30 11
|
begin;
|
delete from tab1 where a = 33;
|
delete from tab1 where a = 34;
|
@@ -1272,8 +1273,8 @@
|
SELECT name,count_reset FROM information_schema.innodb_metrics
|
WHERE name like 'index_page_merge_%';
|
name count_reset
|
-index_page_merge_attempts 0
|
-index_page_merge_successful 0
|
+index_page_merge_attempts 1
|
+index_page_merge_successful 1
|
select PAGE_NUMBER, NUMBER_RECORDS
|
from INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES s1,
|
INFORMATION_SCHEMA.INNODB_BUFFER_PAGE s2
|
@@ -1283,30 +1284,31 @@
|
3 22
|
4 2
|
27 11
|
-28 11
|
+28 9
|
+30 11
|
delete from tab1 where a = 32;
|
InnoDB 0 transactions not purged
|
# check page merge happens (MERGE_THRESHOLD=50 causes merge here)
|
SELECT name,count_reset FROM information_schema.innodb_metrics
|
WHERE name like 'index_page_merge_%';
|
name count_reset
|
-index_page_merge_attempts 0
|
-index_page_merge_successful 0
|
+index_page_merge_attempts 1
|
+index_page_merge_successful 1
|
delete from tab1 where a = 31;
|
InnoDB 0 transactions not purged
|
# check page merge happens (MERGE_THRESHOLD=45 causes merge here)
|
SELECT name,count_reset FROM information_schema.innodb_metrics
|
WHERE name like 'index_page_merge_%';
|
name count_reset
|
-index_page_merge_attempts 1
|
-index_page_merge_successful 1
|
+index_page_merge_attempts 2
|
+index_page_merge_successful 2
|
delete from tab1 where a = 30;
|
InnoDB 0 transactions not purged
|
# check page merge happens (MERGE_THRESHOLD=40 causes merge here)
|
SELECT name,count_reset FROM information_schema.innodb_metrics
|
WHERE name like 'index_page_merge_%';
|
name count_reset
|
-index_page_merge_attempts 2
|
-index_page_merge_successful 2
|
+index_page_merge_attempts 3
|
+index_page_merge_successful 3
|
DROP TABLE tab1;
|
SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;
|