Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-905

Database history topics are having lot of flush & savepoints statements

    XMLWordPrintable

Details

    • Feature Request
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 0.8.2.Final
    • None
    • mysql-connector
    • None

    Description

      In database history topic, lot of SavePoints & Flush statements are coming which fills the ever growing history topic. I know these can be filter from a property ddl.filter but having these explicitly will improve debezium defaults.

      Following are the messages:

      {
        "source" : {
          "server" : "slave"
        },
        "position" : {
          "ts_sec" : 1536312968,
          "file" : "mysql-bin-changelog.208420",
          "pos" : 31286764,
          "server_id" : 995438359,
          "event" : 1
        },
        "databaseName" : "",
        "ddl" : "flush status"
      }
      
      {
        "source" : {
          "server" : "slave"
        },
        "position" : {
          "ts_sec" : 1536313103,
          "file" : "mysql-bin-changelog.208420",
          "pos" : 113556435,
          "server_id" : 995438359,
          "event" : 3
        },
        "databaseName" : "goibibo",
        "ddl" : "SAVEPOINT `s140033162643200_x1`"
      }
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              shivamsharma_jira Shivam Sharma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: