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

Option to put into slow log any transaction that was retried in parallel replication

    Details

      Description

      In optimistic parallel replication (MDEV-6676), we speculatively apply
      transactions in parallel, even if they might conflict. If too many conflicts
      happen, excessive retry might degrade performance.

      The DBA needs some way to monitor for such problems. One good way would seem
      to have an option to add to the slow query log any transactions that were
      retried due to parallel replication conflicts. Possibly with extra information
      such as duration of transaction and similar.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            serg Sergei Golubchik added a comment -

            I'm not sure that slow log is a good match for this kind of events

            Show
            serg Sergei Golubchik added a comment - I'm not sure that slow log is a good match for this kind of events

              People

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

                Dates

                • Created:
                  Updated: