dbrowse

Server Threads

This node is informative, descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Synopsis

This view displays a list of all active threads for the current database.

Node/View

[skip to the dbrowse Navigation information]

Description of Results

This page represents the same information you would receive if you ran the mysql> show processlist from the MySQL monitor program. Running the mysqladmin program with the processlist parameter will return the same results.

I have modified the output slightly to only return threads that are related to the current database. Depending on how you have your grant tables configured, and the privileges set for the user connecting to the server, you may see variations on these results. I have omitted the User column for this very reason, and for security purposes because this is live data you are looking at. See the MySQL access Privilege System for more information on security, privileges, and grant tables.

MySQL Terms

Thread

The thread ID for each client connection in the list. See also Thread ID from the Brief Server Status view.

Host

The host name for each thread. In these examples they are all localhost meaning the client and the server are on the same machine. For remote clients this field would indicate the connecting host followed by the port number, like this: host:port. More information on hosts, ports and networking sockets can be found at the Brief Server Status and Server Variables views.

DB

The active database.

Exec

The command being executed by the thread. Since many threads happen so quickly this field will most often show the command is sleeping, or waiting for a new command to execute. These types of threads are normally associated with persistent connections, which can provide better performance from the server.

Time

The time, in seconds, this thread has been active.

State

The state the thread is currently in. A full list of states and their meanings can be found at the Show Processlist MySQL Reference Manual section.

Query

The SQL query being processed (if any).

Navigation

This is a terminating view for the active database. Try the interactive or query path navigation tools provided with this application or use your Web browser to return to the previous view.