Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13915

STOP SLAVE takes very long time on a busy system

Details

    Description

      150     system user             NULL    Slave_IO        66361   Waiting for master to send event        NULL    0.000
      152     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      153     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      154     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      155     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      156     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      157     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      158     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      159     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      160     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      162     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      161     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      163     system user             NULL    Slave_worker    0       Write_rows_log_event::write_row(-1)     NULL    0.000
      151     system user             NULL    Slave_SQL       1090    Reading event from the relay log        NULL    0.000
      2415    root    127.0.0.1:42392 NULL    Query   835     Killing slave   STOP SLAVE      0.000
      

      slave machine configuration:

      sync_master_info          = 500000
      sync_relay_log            = 100000
      sync_relay_log_info       = 500000
      slave_parallel_max_queued = 67108864
      slave_parallel_mode       = optimistic
      slave_parallel_threads    = 12
      

      Is that normal?

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            3d 15h 37m 1
            Brandon Nesterenko made transition -
            Confirmed In Progress
            1985d 3h 49m 1
            Brandon Nesterenko made transition -
            In Progress In Review
            45s 1
            Brandon Nesterenko made transition -
            Stalled In Review
            39d 1h 55m 1
            Andrei Elkin made transition -
            In Review Stalled
            42d 13h 28m 2
            Brandon Nesterenko made transition -
            Closed Stalled
            14h 4m 1
            Brandon Nesterenko made transition -
            Stalled In Progress
            8d 15h 10m 2
            Andrei Elkin made transition -
            In Progress Closed
            34d 15h 41m 2

            People

              bnestere Brandon Nesterenko
              mxu Michael Xu
              Votes:
              3 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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