Table of Contents
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).
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.
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
button.
If you have selected one or more threads, you can terminate them
by clicking 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
button on your own threads has
no effect; on Linux, that button is disabled when selecting your
own threads.
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 username and
selecting 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 appropriate headings
(Num.
, Full Name
, or
Description
).
Clicking on a username 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
button, allowing you to terminate all threads of that user with a single click. This command is also available by right clicking on the username. Clicking on an individual thread in the lower box enables the 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
button.