Slow Query Log Page
The Slow Query Log page displays a table where each row represents a SQL query that took too long to complete.
To open the Slow Query Log page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Activity | Slow Query Log.
Slow Query Log entries
Note: The Slow Query Log is populated only in MySQL 5.1.12 and later.
Database variables that govern the behavior of the Slow Query Log are:
|
long_query_time |
A "slow" SQL query is one that takes longer than long_query_time seconds to complete. The default value is 10. |
|
slow_query_log |
Enable or disable the Slow Query Log (ON or OFF). |
|
slow_query_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.
Slow Query Log grid
Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
|
Column |
Description |
|---|---|
|
Start Time |
When MySQL began executing the query. |
|
User@Host |
The user account that submitted the query. |
|
Query Time |
The time taken to complete the query. |
|
Lock Time |
The time taken to lock the required database table. This is NOT counted as execution time. |
|
Rows Sent |
The number of table rows submitted for processing. |
|
Rows Examined |
The number of table rows that MySQL examined while executing the query. |
|
Database |
The database instance on which the query ran. |
|
SQL Text |
The text of the executed SQL statement. |
|
Server ID |
The ID of the server where the MySQL command was executed. |