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

Database history topics are having lot of flush & savepoints statements

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 0.8.2.Final
    • mysql-connector
    • None

      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`"
      }
      

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

              Created:
              Updated:
              Resolved: