Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-408

Connections to backend databases do not clear promptly

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.1
    • 1.3.0
    • Core
    • None
    • Tested CentOS 6.5 but probably all

    Description

      Running a test that consists of constantly repeated runs of a PHP program that makes a database connection, runs a simple SQL query, disconnects causes a large number of processes to appear on the backend databases. Backend configuration single master plus single slave. MaxScale using read-write router or connection router and 6 threads. The effect is seen on both master and slave.

      Running the same test directly against the backend master server shows one or zero connections in the process list.

      Running the test with MaxScale configured for a single thread eliminates the problem, suggesting that the zombie processing is not clearing quickly. The effect is also much smaller if 2 threads are configured. Enabling or disabling persistent connections has relatively little impact.

      Hardware environment is a Digital Ocean VPS with a single core.

      Attachments

        Activity

          People

            martin brampton martin brampton (Inactive)
            martin brampton martin brampton (Inactive)
            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.