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

STOP SLAVE takes very long time on a busy system

    XMLWordPrintable

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

            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.