Chapter 12. Server Connections

Table of Contents

12.1. Introduction
12.2. Threads
12.3. User Connections

12.1. Introduction

This section allows you to view and manage the current connections to the server (also called threads). If you have the PROCESS privilege, you can see all threads. If you have the SUPER privilege, you can also terminate threads other than your own. (Note that the SUPER privilege is available for MySQL servers as of version 4.0.3 only.) Otherwise, you can see your own threads only. See SHOW PROCESSLIST Syntax, for more information. See Privileges Provided by MySQL, for more information on the PROCESS and the SUPER privilege (and other available privileges as well).

Note

When you click the Server Connections section You will see an additional thread for the user you logged in as because the values displayed are retrieved from the MySQL server via an additional separate connection.

12.2. Threads

This tab allows you to view all connections to the server (threads). By default, threads are sorted by their PID (MySQL process identification number), but you can change that order by clicking on the appropriate headings (User, Host, etc.). You can select one or more threads using the mouse or the keyboard.

To reload the process list from the server, press the Refresh button.

If you have selected one or more threads, you can terminate them by clicking the Kill Thread button, or by right-clicking on that thread. Remember that you need the PROCESS privilege to see threads other than your own, and the SUPER privilege to kill threads other than your own. Furthermore, note that MySQL Administrator imposes a restriction that prevents you from terminating your own threads. On Windows, using the Kill Thread button on your own threads has no effect; on Linux, that button is disabled when selecting your own threads.

12.3. User Connections

This tab displays all connections to the server (threads), but in a different way than the Threads tab does: You will see users rather than individual threads. The number of connections for each user is listed under Num.. Right-clicking on a user name and selecting Show User Infos displays the Full Name and the Description, as specified in the User Information tab of the User Administration section. Initially, users are sorted by their MySQL Username, but you can change the order by clicking on the headings (Num., Full Name, or Description). Clicking on a user name will display the individual threads of that user in the lower box of the tab, ordered by PID. Likewise, you can change the order by clicking on one of the headings.

Clicking on a user will enable the Kill User button, allowing you to terminate all threads of that user with a single click. This command is also available by right clicking on the user name. Clicking on an individual thread in the lower box enables the Kill Thread button, which is used to terminate a connection. This command is also available by right clicking on a thread.

To reload the user list from the server, press the Refresh button.