SQL Log

The SQL Log is a powerful tool for monitoring all SQL statements executed within DBACentral for MySQL. It makes every program operation "transparent" - you can always see what really happens on your server. To display the SQL Log pane use the View | SQL Log item.

The SQL Log displays all statements within a list, which contain the following columns:

Execution Time - the time moment, when the statement execution was completed;
Command Type - one of the several available command types: connect, disconnect, or execute.
Database - the name of the database, where the statement was executed;
Command Text - the SQL command text of the executed statement;
Command Result - OK or Error.

Double-click the log item to open the command text in the SQL Executor. Right-click at the list to display the popup menu, which allows you to show/hide any of list columns, save log to a text file, search log by the text in active column, and clear the whole log.