Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

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

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. 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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating