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
Field | Original Value | New Value |
---|---|---|
Resolution | Fixed [ 1 ] | |
Status | Closed [ 6 ] | Reopened [ 4 ] |
Labels | Launchpad |
Fix Version/s | Maria 5.5 [ 11303 ] | |
Labels | Launchpad | Launchpad MariaDB_5.5 |
Resolution | Fixed [ 1 ] | |
Status | Reopened [ 4 ] | Closed [ 6 ] |
Key |
|
MDEV-2133 |
Project | ImportTest [ 10200 ] | MariaDB Development [ 10000 ] |
Workflow | jira [ 21392 ] | defaullt [ 22977 ] |
Key |
|
MDEV-3268 |
Project | ImportTest [ 10200 ] | MariaDB Development [ 10000 ] |
Workflow | jira [ 21392 ] | defaullt [ 24112 ] |
Workflow | defaullt [ 24574 ] | MariaDB v2 [ 45360 ] |
Labels | Launchpad MariaDB_5.5 | Launchpad |
Workflow | MariaDB v2 [ 45360 ] | MariaDB v3 [ 62336 ] |
Workflow | MariaDB v3 [ 62336 ] | MariaDB v4 [ 146131 ] |