Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3730

LP:992983 - Aborted_clients metric is growing up even though formal connection close

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      I tested MariaDB 5.5.23 with sysbench.
      And that time, Aborted_clients metric value is not much grew up.

      But, After I applied MariaDB to production database,
      Aborted_clients is growing up ever even though normal close of client side.

      So, I tested same code with MySQL 5.5.23 community version. But it's okay.

      And, MariaDB(with ThreadPool)'s memory usage is really stable under 2GB(Buffer pool is not including)
      when I test with sysbench.
      But in real service (java application), memory usage is growing up over 6~7GB(without BufferPool).
      I'm not sure Aborted_clients metric is related with this memory usage.
      Could you check this out ?

      Thanks.

      after test status----------------------------------------------------------------------------------
      root@localhost:(none) 10:22:10>show global status like 'Aborted_clients';
      ----------------------+

      Variable_name Value

      ----------------------+

      Aborted_clients 100

      ----------------------+

      mysql> show global status like 'Aborted_clients';
      ----------------------+

      Variable_name Value

      ----------------------+

      Aborted_clients 0

      ----------------------+

      test code --------------------------------------------------------------------------------------------
      public class AbortedClientsTester {
      public static void main(String[] args) throws Exception {
      Connection[] conns = new Connection[100];

      for(int idx=0; idx<100; idx++)

      { conns[idx] = getConnection(); }

      Thread.sleep(1000*10);

      for(int idx=0; idx<100; idx++)

      { conns[idx].close(); }

      }

      protected static Connection getConnection() throws Exception

      { String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://127.0.0.1:3306/sysbench"; String uid = "sysbench"; String pwd = "sysbench"; Class.forName(driver).newInstance(); Connection conn = DriverManager.getConnection(url, uid, pwd); return conn; }

      }

      Attachments

        Activity

          matt Matt (Inactive) created issue -
          ratzpo Rasmus Johansson (Inactive) made changes -
          Field Original Value New Value
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Labels Launchpad
          ratzpo Rasmus Johansson (Inactive) made changes -
          Fix Version/s Maria 5.5 [ 11303 ]
          Labels Launchpad Launchpad MariaDB_5.5
          ratzpo Rasmus Johansson (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Key IMT-7743 MDEV-2133
          Project ImportTest [ 10200 ] MariaDB Development [ 10000 ]
          Workflow jira [ 21392 ] defaullt [ 22977 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Key IMT-7743 MDEV-3268
          Project ImportTest [ 10200 ] MariaDB Development [ 10000 ]
          Workflow jira [ 21392 ] defaullt [ 24112 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Key IMT-7743 MDEV-3730
          Project ImportTest [ 10200 ] MariaDB Development [ 10000 ]
          Workflow jira [ 21392 ] defaullt [ 24574 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 24574 ] MariaDB v2 [ 45360 ]
          serg Sergei Golubchik made changes -
          Labels Launchpad MariaDB_5.5 Launchpad
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 45360 ] MariaDB v3 [ 62336 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62336 ] MariaDB v4 [ 146131 ]

          People

            wlad Vladislav Vaintroub
            matt Matt (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.