产品简介

详细了解如何轻松诊断和解决数据库瓶颈问题。

马上阅读 »

Spotlight on MySQL

实时诊断MySQL故障

Spotlight® on MySQL通过在一个直观的用户界面中以图表的形式显示所有的数据库活动来实时诊断MySQL故障，使您能够在最短的时间内对这些问题采取应对措施。 利用这个MySQL监控工具，您可以从性能问题的源头深入挖掘信息。 此外，由于您的MySQL数据库具有独一无二的运行性质，Spotlight可自行校准至正常数据库活动的基准。 这使得Spotlight能够自动建立内部流程速度和其他活动指标。 当达到阈值时，软件会自动发送图像或音频提示。

直观显示——从单个显示器中实时观察MySQL数据库活动，包括流程和配置的设置。

故障快速检测——使用流程、图形和图标，在复杂的数据共享环境中找出性能瓶颈问题和故障区域。

音频和图像警报——当关键指标阈值被触发时将会收到提示信息，以防止故障对最终用户造成影响。

快速诊断——分析故障区域的关键信息，从而更快进行诊断。

深入挖掘——查看CPU、输入和输出、内存和流程等操作系统指标。

System Requirements

Before installing Spotlight on MySQL, ensure your system meets the following minimum hardware and software requirements:

Client Requirements

Platform

A Pentium-based or equivalent PC with:

  • A 1.2 GHz Processor (recommended minimum).
  • A monitor capable of supporting a resolution of 1280x1024 or larger. (You should also set the display to use the 64K color palette [65536 colors].)
  • A CD-ROM drive or Internet connection. Spotlight can be downloaded from the Internet or installed from compact disc. The CD-ROM drive should be attached to the PC on which Spotlight is to be installed. A drive mapped to a network device could be used if a local CD-ROM is not available.
  • A printer (optional). Spotlight reports can be printed on a laser or bubble jet printer. You can print graphs in color if your printer provides this capability.
  • A sound card and speakers (optional). Spotlight can use sound to alert you when a threshold is reached. You must have a sound card and speakers installed on your PC for this feature to work.
Memory512 megabytes of RAM (minimum). 1 gigabyte recommended. Memory consumption will increase for multiple simultaneous connections.
Hard Disk Space1 gigabyte of free disk space. This should exist on a local disk drive rather than a network drive. Extra disk space will be required if you choose to log historical snapshots from within Spotlight.
Operating SystemMicrosoft Windows Server 2008 64-bit
Microsoft Windows Server 2003 32-bit and 64-bit
Microsoft Windows 7 32-bit and 64-bit
Microsoft Windows Vista Business 32-bit and 64-bit (Service Pack 1 or later)
Microsoft Windows XP Professional 32-bit and 64-bit (Service Pack 1 or later)
Additional Software

MySQL. Spotlight on MySQL supports MySQL versions 5.0.3 or later that employ the InnoDB storage engine. With reduced functionality, it also supports versions of MySQL that use other storage engines (such as MyISAM). Spotlight on MySQL may NOT support versions of the MySQL server prior to 5.0.3.

Server Requirements

Database Server

The following MySQL database servers are supported for database queries. (You must have the Database Administrator [DBA] user ID and password for the database you want to diagnose.)

  • Version 5.0.3 and later.
Operating System ServerThe following server operating systems are supported for Operating System Server queries:
Unix:
  • Sun Solaris 10.
  • Red Hat and SUSE operating systems running Linux 2.4 and 2.6 kernels.
Microsoft Windows:
  • Microsoft Windows Server 2008 64-bit
  • Microsoft Windows Server 2003 32-bit and 64-bit
  • Microsoft Windows XP Professional 32-bit and 64-bit (Service Pack 1 or later)
  • Microsoft Windows Vista Business 32-bit and 64-bit (Service Pack 1 or later)
  • Microsoft Windows 7 32-bit and 64-bit
 

相关产品