General Log Page
The General Log page displays a table where each row represents a recent MySQL event for the current connection.
To open the General Log page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Activity | General Log.
General Log entries
Note: The Slow Query Log is populated only in MySQL 5.1.12 and later.
The MySQL server writes an entry to the General Log when:
- Clients connect to, or disconnect from, the server.
- The server receives a SQL statement from a client.
Queries appear in the log in the order in which they are received, which is not necessarily the order in which they are executed. Database variables that govern the behavior of the General Log are:
|
general_log |
Enable or disable the General Log (ON or OFF). |
|
general_log_file |
The name of the log file. |
Note: Spotlight displays the current values for these variables in the Configuration Page of the Activity drilldown.
General Log grid
Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
|
Column |
Description |
|---|---|
|
Event Time |
When the event occurred. |
|
User@Host |
The user account that submitted the event or query. |
|
Command Type |
The MySQL command for the logged event (CONNECT, QUERY). |
|
Argument |
Details of the MySQL event.
|
|
Server ID |
The ID of the server where the MySQL command was executed. |
|
Thread ID |
The ID of the thread executing the MySQL command. |