Use Spotlight on MySQL to monitor your MySQL databases, detect and resolve problems.
|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.
Select the database to connect to.
Note: Ensure the Unix or Windows server on which the MySQL database is installed is accessible to Spotlight.
Click File | Connect
Select Spotlight on MySQL on the Connections menu.
Double-click Add new connection.
Fill in the connection Properties | Details page. MySQL Connection Details
This is the display name for the connection in Spotlight.
Tip: Fill in the Host field first.
MySQL connection details
|Enter the name of the host machine for the MySQL database.
Enter the user name to login to the MySQL database.
Enter the password to login to the MySQL database.
|Enter the port used for the Spotlight on MySQL connection. The default value is 3306.
|Select the name of the database that you wish to connect to.
OS Connection Details
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.
Enter the address of the host machine for the MySQL database.
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.
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).
Type the user name to login to the database server.
Note: When OS Type is Windows:
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.
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