5.4 Client Connections

The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill statements and connections, and view additional connection details and attributes.


The connection details viewer requires MySQL 5.6 or greater. Only basic connection information is available for previous versions of MySQL, such as the connection hosts, database, and state.

Figure 5.29 Client Connection Overview

Client Connection Overview

Client Connections and Metadata locks

The Client Connections management window includes a Show Details for connections to MySQL 5.6 and above. These details are separated into three tabs:

  • Details: connection details such as Process ID, Type, User, Host, Instrumented, and additional information.

    Figure 5.30 Client Connections Details

    Client Connection Details

  • Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers. Sometimes a query might be blocked while being manipulated by another connection from another user. The Locks feature utilizes these MySQL metadata locks (MDL) to show the locked connections that are blocked or being waiting on, and shows information about the locks, what they are waiting for, and what they hold.

    Figure 5.31 Metadata Locks Browser

    Metadata Locks Browser


    The metadata lock information is provided in the performance schema as of MySQL server 5.7.3.

  • Attributes: these are connection attributes such as OS, Client Name, Client Version, and Platform.

    Figure 5.32 Client Connection Attributes

    Client Connection Attributes

User Comments
Sign Up Login You must be logged in to post a comment.