Online Documentation for SQL Manager for MySQL

Viewing general query log

The General Query Log tab of the Server Properties viewer displays the query log for the specified server.

Note: This tab is only available for MySQL version 5.1.6 and higher and when the server is configured for logging to table. For more information refer to the official MySQL server documentation.

The list displays the server events as a grid with the following columns: Event Date, Event Time, User and Host, Thread, Server ID, Command, Command Text. 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 query log items are not available for editing.