Chatta subito con l'assistenza
Chat con il supporto

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

Spotlight on MySQL

Use Spotlight on MySQL to monitor your MySQL databases, detect and resolve problems.

Section

Description

Connect to a MySQL Database Create / Modify / Delete connections to MySQL systems.
Spotlight on MySQL Home Page The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.
Spotlight on MySQL Alarms

Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.

Spotlight on MySQL Drilldowns When you have isolated a problem, you can display a drilldown page, whose charts and tables provide a detailed breakdown of the underlying statistics.

 

Connect to a MySQL Database

  1. From the Spotlight Browser select All connectionsSpotlight on MySQL
  2. Select the database to connect to.

     

Add a MySQL database to the list of connections

Note: Ensure the Unix or Windows server on which the MySQL database is installed is accessible to Spotlight.

  1. Click File | Connect to open the Spotlight Connection Manager.

  2. Select Spotlight on MySQL on the Connections menu.

  3. Double-click Add new connection.

  4. Fill in the connection Properties | Details page. MySQL Connection Details

 

Related Topics

Spotlight Browser

MySQL Connection Details

Field Description
Connection name

This is the display name for the connection in Spotlight.

Tip: Fill in the Host field first.

MySQL connection details

Field Description
Host Enter the name of the host machine for the MySQL database.
Username

Enter the user name to login to the MySQL database.

Password

Enter the password to login to the MySQL database.

Port Enter the port used for the Spotlight on MySQL connection. The default value is 3306.
Database Select the name of the database that you wish to connect to.

OS Connection Details

Field Description
Monitor OS

Select to monitor the operating system on the database server.

Tip: Clear this option if the database is running on an operating system that is NOT supported by Spotlight on MySQL. If you leave this option checked and Spotlight on MySQL is unable to collect statistics from the server operating system, you may experience errors.

Address

Enter the address of the host machine for the MySQL database.

OS Type

Select the type of operating system.

  • Windows
  • Unix(REXEC)
  • Unix(SSH)

If you select one of the Unix systems, make sure the SSH or REXEC daemon is running on the database server and is configured to receive remote connections.

SSH Port

Enter the port number for SSH (secure shell) connection to the database server. The default value is 22.

Note: Applicable when OS Type is Unix(SSH).

Username

Type the user name to login to the database server.

Note: When OS Type is Windows:

  • Not required if your login details have been assigned remote access to the registry of the database server.
  • Ensure the user has access to the registry of the server.

Password

Type the user password to login to the database server (if required).

Click Save password details (for this connection) to save all the entered password details.

 

Related Topics

Spotlight Connection Manager

All connections

Spotlight Today

Spotlight on MySQL Home Page

The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.

Related operating system statistics are grouped together on panels that are connected by a series of graphical flows and icons. Spotlight updates these flows in real time so you can see how quickly data is moving through the system. The icons change color as Spotlight alarms are raised, upgraded, downgraded and canceled.

Tip: Hover the mouse pointer over a panel component for more information.

To see the Spotlight on MySQL Home Page

  1. Select the Spotlight on MySQL connection from the Spotlight browser.
  2. Click .

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione