Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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:

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.

  • 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