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

Add Replication Performance Diagnostics

    XMLWordPrintable

Details

    Description

      It is currently very hard to diagnose slave lag problems. This ticket is to track work to extend the replica with various diagnostic capabilities to make it easier to track down performance issues.

      One idea so far is to have dynamic profiling that only turns on when the slave starts lagging. For example, it could use the perf C API; or automatically capture thread stacks.

      Estimations:

      • 30 days for the design, dev and review
      • 12 days for testing
      • Total 42 mandays

      Attachments

        Issue Links

          includes

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21322 report slave progress to the master

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Task - A task that needs to be done. MDEV-7340 [PATCH] parallel replication status variables

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-5296 No status information available for parallel replication

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-41142 Deprecate rpl_semi_sync_master_trace_level/rpl_semi_sync_slave_trace_level

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              Elkin Andrei Elkin
              bnestere Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 42d
                  42d
                  Remaining:
                  Remaining Estimate - 42d
                  42d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

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