Shulou(Shulou.com)05/31 Report--

This article introduces the analysis of the possible reasons for the increasing value of MySQL Aborted_connects. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

Recently, I logged in to the database, looked at the value of Aborted_clients, and found that it was growing.

Mysql (mdba@localhost:test 03:36:36) > show global status like 'abort%'

+-+ +

| | Variable_name | Value |

+-+ +

| | Aborted_clients | 5185350 | |

| | Aborted_connects | 1788 | |

+-+ +

2 rows in set (0.00 sec)

Mysql (mdba@localhost:test 03:36:37) > show global status like 'abort%'

+-+ +

| | Variable_name | Value |

+-+ +

| | Aborted_clients | 5185351 | |

| | Aborted_connects | 1788 | |

+-+ +

2 rows in set (0.00 sec)

Mysql (mdba@localhost:test 03:36:38) > show global status like 'abort%'

+-+ +

| | Variable_name | Value |

+-+ +

| | Aborted_clients | 5185352 | |

| | Aborted_connects | 1788 | |

+-+ +

2 rows in set (0.00 sec)

Mysql (mdba@localhost:test 03:36:39) > show global status like 'abort%'

+-+ +

| | Variable_name | Value |

+-+ +

| | Aborted_clients | 5185355 | |

| | Aborted_connects | 1788 | |

+-+ +

2 rows in set (0.00 sec)

Cause analysis:

The Aborted Clients value explains:

The number of connections that were aborted because the client died without closing the connection properly.

When the abort clients increases, it means that a client successfully establishes a connection, but is quickly disconnected or terminated, which usually occurs in an unstable network environment.

The main possible reasons are:

A) the client did not actively close the mysql connection mysql_close ().

B) the wait_timeout setting is very short and is killed by mysql.

C) the client was killed for some reason.

The Aborted Connection value explains:

The number of failed attempts to connect to the MySQL server.

This number will surge when there are a large number of links that cannot connect to mysql.

The main possible reasons are:

A) No authorization or incorrect password. There will be the following Access denied for 'user'@'host' in the general error log

B) the number of connections is full General error report includes (too many connections)

C) when the link time limit is exceeded, this parameter controls connect_timeout (mysql defaults to 10s. Basically, unless the network environment is extremely bad, it will not time out. )

So much for the analysis of the possible reasons for the increasing value of MySQL Aborted_connects. I hope the above content can be of some help to you and can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.