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

Performance Enhancement of Informix Connector

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Blocker Blocker
    • Backlog
    • None
    • informix-connector
    • None
    • False
    • None
    • False

      Hi, 

      I am using Informix source connector to capture all events occurring on a table existing on the Informix database and publishing messages in the topic on KAFKA. However, using the attached configurations, I am only able to achieve 600 TPS and facing delays of 3 minutes between the insert done and the message being published. The delay only worsens as I increase the TPS and the targeted TPS is 1000. 

       

      Kindly suggest configurations or methods which could be used to improve the TPS without facing big delays. 

        1. informix source connector.json
          2 kB
        2. image-2024-03-18-11-46-03-539.png
          image-2024-03-18-11-46-03-539.png
          34 kB
        3. image-2024-05-22-13-23-37-517.png
          image-2024-05-22-13-23-37-517.png
          101 kB
        4. image-2024-05-22-13-50-01-593.png
          image-2024-05-22-13-50-01-593.png
          48 kB
        5. image-2024-05-26-05-15-07-267.png
          image-2024-05-26-05-15-07-267.png
          177 kB
        6. image-2024-05-26-05-15-31-950.png
          image-2024-05-26-05-15-31-950.png
          68 kB
        7. image-2024-05-26-05-20-49-219.png
          image-2024-05-26-05-20-49-219.png
          951 kB
        8. source-recording.jfr
          4.12 MB
        9. source-recording-1.jfr
          4.12 MB
        10. kafka-connect-recording-updated.jfr
          6.64 MB
        11. connect-flight-recording_7june.jfr
          5.95 MB
        12. image-2024-06-11-12-49-15-009.png
          image-2024-06-11-12-49-15-009.png
          12 kB
        13. image-2024-06-25-15-35-14-434.png
          image-2024-06-25-15-35-14-434.png
          48 kB

              Unassigned Unassigned
              maaheen11 Maaheen Yasin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: