MySQL connections issue

upulps

• May 08, 2017 03:29

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

• 

  cPanelMichael

  • May 09, 2017 18:08

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

  0
• 

  upulps

  • May 10, 2017 06:33

  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,

  0
• 

  cPanelMichael

  • May 10, 2017 17:49

  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.

  0

Please sign in to leave a comment.