MySQL connections issue

[upulps]

Hi,

Please be kind enough to support for below.
Why mysql connections are not refresh ?

Thanks,
upulps

 

[cPanelMichael]

Hello,

Do you notice hanging MySQL processes when using the "mysqladmin processlist" command on the system?

Thank you.

 

[upulps]

Hi,

There is no any hanging process to show. Now connection, Aborted_connects and max_connection are increasing.

mysql> show status like '%con%';
+-----------------------------------------------+----------+
| Variable_name | Value |
+-----------------------------------------------+----------+
| Aborted_connects | 1247 |
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 0 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 10083182 |
| Max_used_connections | 720 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_session_connect_attrs_lost | 0 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 13 |
+-----------------------------------------------+----------+
16 rows in set (0.00 sec)

Thanks,

 

[cPanelMichael]

There is no any hanging process to show. Now connection, Aborted_connects and max_connection are increasing.

Hello,

The following thread is a good place to start if you want to tune your MySQL configuration:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.