MySQL 实验室 因为专注,所以专业。

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: 15 MySQL Enterprise Monitor
    • MySQL 5.1 Reference Manual
    • Preface, Notes, Licenses
    • 1 General Information
    • 2 Installing and Upgrading MySQL
    • 3 Tutorial
    • 4 MySQL Programs
    • 5 MySQL Server Administration
    • 6 Backup and Recovery
    • 7 Optimization
    • 8 Language Structure
    • 9 Internationalization and Localization
    • 10 Data Types
    • 11 Functions and Operators
    • 12 SQL Statement Syntax
    • 13 Storage Engines
    • 14 High Availability and Scalability
    • 15 MySQL Enterprise Monitor
    • 16 Replication
    • 17 MySQL Cluster NDB 6.X/7.X
    • 18 Partitioning
    • 19 Stored Programs and Views
    • 20 INFORMATION_SCHEMA Tables
    • 21 Connectors and APIs
    • 22 Extending MySQL
    • A MySQL 5.1 Frequently Asked Questions
    • B Errors, Error Codes, and Common Problems
    • C MySQL Change History
    • D Restrictions and Limits
    • Index
    • Standard Index
    • C Function Index
    • Command Index
    • Function Index
    • INFORMATION_SCHEMA Index
    • Transaction Isolation Level Index
    • JOIN Types Index
    • Operator Index
    • Option Index
    • Privileges Index
    • SQL Modes Index
    • Status Variable Index
    • Statement/Syntax Index
    • System Variable Index

    Chapter 15. MySQL Enterprise Monitor

    Table of Contents     [+/-]

    15.1. An Overview of the Service     [+/-]
    15.1.1. The Service Architecture
    15.1.2. Service Features
    15.1.3. Security
    15.2. Conventions Used in This Document
    15.3. Installation and Upgrades     [+/-]
    15.3.1. User Roles
    15.3.2. Service Manager Installation
    15.3.3. Monitor Agent Installation
    15.3.4. Unattended Installation
    15.3.5. Post-Installation Considerations
    15.3.6. Upgrading, Re-Installing or Changing Your Installation
    15.3.7. Uninstalling the MySQL Enterprise Monitor
    15.4. MySQL Enterprise Dashboard     [+/-]
    15.4.1. The Server Tree
    15.4.2. The Server Graphs and Critical Events
    15.4.3. The Heat Chart
    15.5. The Settings Page     [+/-]
    15.5.1. Global Settings
    15.5.2. User Preferences
    15.5.3. Manage Servers
    15.5.4. Managing Users
    15.5.5. Manage Notification Groups
    15.5.6. Logs
    15.5.7. The Product Information Screen
    15.6. The What's New Page     [+/-]
    15.6.1. Setting What's New Configuration
    15.7. The Advisors Page     [+/-]
    15.7.1. Installing and Updating Advisors
    15.7.2. Scheduling Rules
    15.7.3. Editing Built-in Rules
    15.7.4. Creating Advisors and Rules
    15.7.5. Creating a Custom Data Collection Item
    15.7.6. Disabling and Unscheduling Rules
    15.7.7. Advisor Blackout Periods
    15.8. The Events Page     [+/-]
    15.8.1. Closing an Event
    15.8.2. Notification of Events
    15.9. The Graphs Page     [+/-]
    15.9.1. Displaying Graphs
    15.9.2. Setting an Interval
    15.9.3. Setting a Time Span
    15.10. The Query Analyzer Page     [+/-]
    15.10.1. Enabling Query Analyzer
    15.10.2. Getting Detailed Query Information
    15.10.3. Using Graphs to Identify Queries
    15.10.4. Filtering Query Analyzer Data
    15.10.5. Using Query Analyzer Data
    15.10.6. Troubleshooting Query Analyzer
    15.10.7. Query Analyzer Settings
    15.11. The Replication Page     [+/-]
    15.11.1. Replication Page Details
    15.12. MySQL Enterprise Monitor Reference     [+/-]
    15.12.1. MySQL Enterprise Monitor Limitations
    15.12.2. Supported Browsers
    15.12.3. Installation Requirements
    15.12.4. Creating a new SSL KeyStore
    15.12.5. Choosing Suitable MySQL Enterprise Service Manager Hardware Configurations
    15.12.6. MySQL Enterprise Monitor Agent Reference
    15.12.7. Configuring Tomcat Parameters
    15.12.8. Backing up MySQL Enterprise Service Manager
    15.12.9. Migrating 1.3.x Historical Data to MySQL Enterprise Monitor 2.0
    15.12.10. Regular MySQL Enterprise Monitor Maintenance
    15.12.11. Advisor/Graph Reference
    15.13. MySQL Enterprise Monitor Frequently Asked Questions

    Note

    MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.

    The MySQL Enterprise Monitor serves as an automated assistant for MySQL database administrators. This service is designed to help administrators with their day-to-day tasks by monitoring MySQL servers and identifying potential problems. These features are designed to save the database administrator's time and effort by providing the information you need through a simplified interface.

    An extension of existing MySQL Enterprise services, MySQL Enterprise Monitor monitors enterprise database environments and provides expert advice on how customers can tighten security and optimize the performance and uptime of their MySQL servers.

    MySQL Enterprise Monitor helps administrators:

    • Intelligently stay up to date with releases and bug fixes

    • Know what's going on with their system

    • Manage day-to-day database maintenance tasks

    • Improve the performance of their system

    • Manage and prevent crises

    The MySQL Enterprise Monitor was designed to tackle the job of managing the performance of any number of MySQL database servers, regardless of their physical or geographical location. Although MySQL Enterprise Monitor can easily track just a handful of MySQL servers, the service is specifically designed to greatly curtail the time it takes to get a handle on the availability and performance levels of many database servers at once.

    The MySQL Enterprise Monitor does this by providing an web-based interface—called the Enterprise Dashboard—that serves as the portal for viewing information about your MySQL database servers. MySQL professionals can manage all their servers by group or individually if need be.

    The Enterprise Dashboard web interface does not have to be installed on individual desktops, but is instead available from a centrally located machine that serves as the main location for the Monitoring and Advisory service.