MySQL Enterprise White Papers

MySQL Query Analyzer: Overview

The MySQL Query Analyzer helps developers and DBAs improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the new MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor and fine-tune applications in production environments.
More »

MySQL Enterprise Monitor: What's New, Fall 2008 Release

MySQL is proud to announce the Fall 2008 Release of the MySQL Enterprise Monitor. A new MySQL Query Analyzer allows you to improve application performance by quickly identifying and fixing problem queries. Plus, new Advisor Rules enable DBAs to implement more MySQL best practices relating to administration, security and performance.
More »

MySQL Enterprise Monitor: Getting Started Guide

This guide will help you get started with the Enterprise Monitor. It will step you through the basics of installation and configuration and will introduce how the MySQL Advisors and Rules can be automated to proactively scan your MySQL servers for potential problems and tuning opportunities. It will also show you how to drill into Events and correlate best practice violations with related MySQL and operating system activity using the Heat Chart and Graphs.
More »

MySQL Enterprise Monitor: Business Overview

Whether they are working for large companies or for small businesses with only a handful of MySQL servers, the MySQL Enterprise Monitor is designed to scale DBA resources to include MySQL expertise by providing a unified, informed view into the health, security, performance and availability of the entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.
More »

MySQL Enterprise: Database. Monitoring. Support.

Whether you are building and supporting commercial websites, distributing enterprise applications or engineering advanced communications networks, the technologies used to run your organization must be readily adaptable for you to remain competitive. This paper explores how you can confidently deploy MySQL, the "M" in the LAMP stack, as part of an innovative and cost-effective platform ideal for delivering internet-based applications. It further examines the challenges associated with building and supporting scalable, data-driven online applications, using open source web 2.0 technologies, and provides a detailed overview of MySQL Enterprise, which includes the database and monitoring software and production support services that are designed to alleviate these challenges. Finally, this paper points to practical examples of how existing MySQL customers leverage their MySQL Enterprise subscriptions to lower their costs and scale their applications in support of their growing business.
More »