Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.8 - 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 Alarms

Spotlight alarms indicate when the MySQL database exceeds acceptable performance thresholds.

Alarm Description

Buffer Pool Hit Rate Alarm

The Buffer Pool Hit Rate alarm fires when the proportion of table data that can be found in the InnoDB buffer pool drops below a specified threshold.

CPU Busy Alarm

The CPU Busy alarm occurs when the total CPU utilization of the system exceeds a threshold. The CPU may encounter a large number of requests, or you may have un-tuned SQL, which unnecessarily uses excessive amounts of CPU.

Inefficient Sort Alarm

The Inefficient Sort alarm fires when the number of temporary files created for sorts is high in comparison to the number of sorts performed.

Low Free Physical RAM Alarm

The Low Free Physical RAM alarm occurs when the server’s available RAM is low.

Query Cache Hit Rate Alarm

The Query Cache Hit Rate alarm fires when the proportion of SQL queries that can be found in the MySQL query cache drops below a specified threshold.

 

Related Topics

Spotlight on MySQL Drilldowns

Once a problem is isolated you can display a drilldown page with charts and tables that provide a detailed breakdown of the underlying statistics.

Drilldown Click to open Keyboard Shortcut Drilldown Pages Description
Top Sessions CTRL+S Top Sessions Page

The pages in the Top Sessions drilldown display information about the users connected to the MySQL database.

Activity CTRL+Y Summary Page | Mutex Page | Sorts Page | Query Cache Page | Configuration Page | Statistics PageInnoDB Status Page | Error Log PageGeneral Log Page | Slow Query Log Page The pages in the Activity drilldown display details of the activity on the MySQL database.
Operating System CTRL+O OS Performance Page | OS Processes Page The pages in the Operating System drilldown display information related to the performance of, and processes on, the operating system where the MySQL server is running.
Alarm Log CTRL+L

Alarm log | Alarms by Time | Spotlight Today

The Alarm Log drilldown displays information on the alarms associated with the MySQL database.

Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. Spotlight on MySQL Alarms

 

Related Topics

Troubleshooting: Connection Problems

Troubleshooting Spotlight on Windows

This section identifies general problems that you may encounter when using Spotlight on Windows, and details how to address those problems. If you do not find a solution in this section then check the Release Notes.

Issues Connecting

Issues Monitoring a Windows Machine

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione