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

Improve processlist reporting of replication threads

        Details

        • Type: Task
        • Status: Closed
        • Priority: Minor
        • Resolution: Won't Fix
        • Fix Version/s: 10.0.4
        • Component/s: None
        • Labels:
          None

          Description

          The "state" and "command" reported by SHOW PROCESSLIST for replication threads
          is lacking.

          Improve it so that DBAs can see more precisely what the threads are doing.

          For the SQL thread, "Command" could be "execute" when replicating row events,
          and "sleep" when waiting for new events from the IO thread. State could be
          "execute row events".

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                The mechanism for updating THD states for processlist is changing with merge of P_S stages into 10.0.

                So seems easier to wait for that code to be merged before doing this - it's not urgent.
                Might also be easier to do it after merge of multi-source replication.

                Show
                knielsen Kristian Nielsen added a comment - The mechanism for updating THD states for processlist is changing with merge of P_S stages into 10.0. So seems easier to wait for that code to be merged before doing this - it's not urgent. Might also be easier to do it after merge of multi-source replication.

                  People

                  • Assignee:
                    knielsen Kristian Nielsen
                    Reporter:
                    knielsen Kristian Nielsen
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour
                      1h