Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

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

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


Enable or disable the General Log (ON or OFF).


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



Event Time

When the event occurred.


The user account that submitted the event or query.

Command Type

The MySQL command for the logged event (CONNECT, QUERY).


Details of the MySQL event.

  • For a query, this is the text of the SQL statement.
  • For a connection event, it is the name of the connected client.

Server ID

The ID of the server where the MySQL command was executed.

Thread ID

The ID of the thread executing the MySQL command.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating