Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - 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

Top Sessions Page

Top Sessions lists all users connected to the MySQL database in logical I/O request order. Clicking a column heading changes the sort order of the table.

To open the Top Sessions page

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. Click Top Sessions.

Actions on the Top Sessions grid

Column Description
Select (Highlight) a session

View detailed information on the session. See:

Kill a session

Right-click the session and select Kill Session.

A message appears with the serial number of the session to be killed. Click Yes to kill the session or click No to leave it running.

Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.

End a MySQL query

Right-click the session and select Kill Query.

A confirmation message appears. Click Yes to kill the query or click No to leave the query running.

Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.

The Top Sessions Grid

Notes:

  • The values in this table are obtained from the output of the SHOW FULL PROCESSLIST or SHOW INNODB STATUS commands.
Column Description

ID

The unique identifier for the user session.

Host

The name of the host from which the user has established a connection.

User

The MySQL account under which the user has connected to the database.

Database

The name of the MySQL database to which the user is currently connected.

State

The current state of the session. If the session is idle, this will be sleeping. Otherwise, the State column shows the current activity undertaken by the user.

Time

The amount of time – in seconds – for which the current query has been running.

Command

The type of command currently running for the session.

Info

More information; usually the text of the SQL statement being executed.

Transaction State

The current state of the transaction (for example, NOT STARTED or ACTIVE). Obtained from the output of the MySQL SHOW INNODB STATUS command.

Queue State

Obtained from the output of the MySQL SHOW INNODB STATUS command.

Lock Heap Size

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Lock Structs.

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Tables in Use

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Tables Locked

Obtained from the output of the MySQL SHOW INNODB STATUS command.

Undo Log Entries

Obtained from the output of the MySQL SHOW INNODB STATUS command.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating