Logging: ./mtr  --mem --repeat=2 innodb_defrag_concurrent

..

=================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

innodb.innodb_defrag_concurrent 'innodb' [ pass ]  29589

innodb.innodb_defrag_concurrent 'innodb' [ 2 fail ]

        Test ended at 2022-05-13 12:39:55

CURRENT_TEST: innodb.innodb_defrag_concurrent

--- /Server_bin/10.8_asan/mysql-test/suite/innodb/r/innodb_defrag_concurrent.result     2022-03-01 17:39:21.000000000 +0100

+++ /Server_bin/10.8_asan/mysql-test/suite/innodb/r/innodb_defrag_concurrent.reject     2022-05-13 12:39:54.905656077 +0200

@@ -46,7 +46,7 @@

 15800

 select count(stat_value) > 0 from mysql.innodb_index_stats where table_name like '%t1%' and  stat_name  in ('n_pages_freed');

 count(stat_value) > 0

-0

+1

 select count(stat_value) > 0 from mysql.innodb_index_stats where table_name like '%t1%' and  stat_name  in ('n_page_split');

 count(stat_value) > 0

 1

mysqltest: Result content mismatch

The reason for that is the following:

The creation of the table t1 leads to records like

select database_name, table_name, index_name, stat_name, stat_value, sample_size

from mysql.innodb_index_stats where table_name like '%t1%' and  stat_name  in ('n_page_split');

database_name	table_name	index_name	stat_name	stat_value	sample_size	

test	t1	PRIMARY	n_page_split	#	NULL	

test	t1	second	n_page_split	#	NULL

After some OPTIMIZE t1 we get some additional record

test	t1	FTS_DOC_ID_INDEX	n_page_split  #	NULL

And these records do not disappear if the table t1 gets dropped.

IMHO this is rather harmless as long as parts of the server

- do not use these values at all

or

- are aware that whatever statistics which is older than the create

  data of a table mentioned is no more valid.

The repetition of innodb_defrag_concurrent meets at its begin this

historic data of the previous execution and fails with result set difference.