The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL connections issue

Discussion in 'Database Discussions' started by upulps, May 8, 2017.

  1. upulps

    upulps Member

    Joined:
    Mar 17, 2017
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi,

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

    Thanks,
    upulps
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
  3. upulps

    upulps Member

    Joined:
    Mar 17, 2017
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    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,
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page