The Navicat server monitor can show the following properties from your selection of MySQL servers:

MySQL Server Process List
MySQL Server Variables
MySQL Server Status

How does the Server Monitor work?

Open the Server Monitor by clicking Server Monitor on the Tool menu. Select the servers that you want to monitor by checking them in the check-listbox on the left hand side of the Server Monitor Window. After you have selected your servers, click on either the Process List, Variables or Status Tab depending on what you want to see.

Process List

Click the Process List Tab to get a list of processes from all the MySQL servers selected in the check-listbox. The list is retrieved from the server(s) by issuing the SHOW [FULL] PROCESSLIST statement.

If you have the process privilege, you can see all processes. Otherwise, you can see only your own processes. The process list provides the following information:

1. The Name of the server as set up in Navicat
2. The ID of the process on the MySQL server
3. The MySQL User of the process
4. The host from which the user is connected
5. The database that the user is currently using
6. The last command that was issued by the user
7. The time, state and info of the process.

Ending Processes on a MySQL Server

If you have the process privilege, you can see and kill all processes on the MySQL server. Otherwise, you can see and kill only your own processes.

To kill a thread on the server, click the Process List button to get a list of processes running on the server. Click on the process you want to kill and then click the End Process button.

Server Variables

Click the Variables Tab to get a list of the MySQL server variables. The list is retrieved from the server by issuing the SHOW VARIABLES statement to the server.

To edit the variable value, just simply select the variable you wish to edit and click on the ... button.

Server Status

Click the Status Tab to get the status of the MySQL server. The status is retrieved from the server by issuing the SHOW STATUS statement to the server.