Details
-
Technical task
-
Status: Approved (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.2
-
None
Description
perfschema.relaylog implicitly relies on being run on a freshly started server.
It checks I/O perfschema values, and expects them to be matching a newly started server.
It didn't cause failures before, because due to MDEV-42198 the test was getting duplicate options which made its set of options unique, so the server was restarted bfore the test. With MDEV-42198 fix, the test can be included into chains of tests, which can cause failures.
+++ /share8t/bld/bb-10.11-elenst/mysql-test/suite/perfschema/r/relaylog.reject 2026-11-11 20:04:13.900256826 +0200
|
@@ -23,7 +23,10 @@
|
where file_name like "%master-%" order by file_name;
|
FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
|
master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
|
+master-bin.000002 wait/io/file/sql/binlog MANY MANY MANY MANY
|
master-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
|
+master-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
|
+master-relay-bin.index wait/io/file/sql/relaylog_index MANY MANY MANY MANY
|
select * from performance_schema.file_summary_by_instance
|
where file_name like "%slave-%" order by file_name;
|
FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIM
|
ER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIM
|
ER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
|
@@ -39,6 +42,7 @@
|
where event_name like "%binlog%" order by file_name;
|
FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
|
master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
|
+master-bin.000002 wait/io/file/sql/binlog MANY MANY MANY MANY
|
master-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
|
select
|
EVENT_NAME,
|
@@ -75,12 +79,14 @@
|
select * from performance_schema.file_summary_by_instance
|
where event_name like "%relaylog%" order by file_name;
|
FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIM
|
ER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIM
|
ER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
|
+/dev/shm/var_auto_Rvu7/12/mysqld.1/data/master-relay-bin.000001 wait/io/file/sql/relaylog 1407374891941888 32 14366072 42476
|
448868 4066216 2 671006 329189 335503 341817 512 2 1527988 618198 763994 909790 512 28 12167078 42476 434518
|
4066216
|
+/dev/shm/var_auto_Rvu7/12/mysqld.1/data/master-relay-bin.index wait/io/file/sql/relaylog_index 1407374891876352 18 18300555 42476 1016554
|
9307984 2 1097488 383145 548744 714343 52 2 2015027 782362 1007370 1232665 52 14 15188040 42476 1084860 9307984
|
select * from performance_schema.file_summary_by_event_name
|
where event_name like "%relaylog%" order by event_name;
|
EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ
|
MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRI
|
TE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
|
-wait/io/file/sql/relaylog 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
0 0 0 0 0 0
|
+wait/io/file/sql/relaylog 34 15295952 0 449729 4066216 2 671006 329189 335503 341817 512 2 1527988 618198 763994
|
909790 512 30 13096958 0 436527 4066216
|
wait/io/file/sql/relaylog_cache 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
-wait/io/file/sql/relaylog_index 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
+wait/io/file/sql/relaylog_index 18 18300555 42476 1016554 9307984 2 1097488 383145 548744 714343 52 2 2015027 782362 1007370 1232665 52 14 15188040 42476 1084860 9307984
|
wait/io/file/sql/relaylog_index_cache 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
select * from performance_schema.events_waits_summary_global_by_event_name
|
where event_name like "%MYSQL_RELAY_LOG%"
|
@@ -91,7 +97,7 @@
|
wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_queue_busy 0 0 0 0 0
|
wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_relay_log_updated 0 0 0 0 0
|
wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_binlog_end_pos 0 0 0 0 0
|
-wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index 0 0 0 0 0
|
+wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index 9 1293222 91553 143500 250264
|
connection slave;
|
"============ Performance schema on slave ============"
|
select * from performance_schema.file_summary_by_instance
|
 |
Result length mismatch
|