Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-402

make tcpKeepAlive option default to true

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 2.0.0-RC
    • Other
    • None

    Description

      Actual tcpKeepAlive option default to false.

      TCP connections consist of two sockets, one on each end of the connection.

      Both sides will keep their socket open indefinitely. This leaves open the possibility that one side may close their socket, either intentionally or due to some error, without informing the other end via FIN. In order to detect this scenario and close stale connections the TCP Keep Alive process is used.

      Since the process doesn't start until a connection has been idle for two hours (this time is OS dependant), and database connection are expensive, better to have a pool that ensure that connection is valid more often than that, but it remain that if it's not the case, driver after 2 hours idle connection must ensure that socket is still ok.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.