Details

    • Technical task
    • Status: Approved (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.4, 11.8, 12.3, 13.2
    • 10.11, 11.4, 11.8, 12.3, 13.2
    • Tests, MTR
    • 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
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Susil Behera Susil Behera
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.