Online Documentation for SQL Manager for MySQL

Viewing process list

The Process List tab of the Server Properties viewer allows you to browse the list of processes running on the server and manage them efficiently.

The list displays the processes as a grid with the following columns: ID, User, Host, DB, Command, Time, State, Info. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Note: The process list items are not available for editing.

Right-click an item within the list to call the context menu allowing you to kill a process or a query, refresh the list, or copy the list to Windows clipboard. Using the context menu you can also export the list of jobs to any of supported output file formats.

Process management tools are also available through the Navigation bar of the Server Properties viewer.