Performance Audit

Comprehensive assessment of MySQL performance

Performance Audit for MySQL identifies a wide range of MySQL performance problems and provides actionable recommendations for improvement. It is an effective way to make your MySQL database faster and more reliable.

Comprehensive Audit Diagnoses MySQL for existing problems and root causes

Delivers Solutions Detailed recipes for addressing found problems

Easy to Budget Service provided under a fixed-fee model

Quick Availability Typically starts in three to five business days

Why Performance Audit?

Comprehensive MySQL performance assessment

Turbocharge MySQL

Fast and reliable database

Get serious about MySQL performance. Through a comprehensive assessment, the service can discover the root causes behind any known, and other yet unknown, performance or reliability issues in your MySQL. The resulting audit report provides detailed, actionable solutions for eliminating the identified problems.

Save Time and Money

It is worth it

All the answers and solutions available within just a few days, without wasting any of your own time, effort or resources. In the long term, save money or delay expensive hardware upgrades as a high performing and well-tuned MySQL can utilise your existing servers more efficiently.

Get Continued Support

Our goal is your success

We extend our help beyond the audit itself, lending a hand to ensure you can get the most from our service. The free post-audit support provides an opportunity to discuss audit results during a conference call, and to follow up with follow-up questions by email. We may even help you implement some of our recommendations.

Service Scope

What is included in Performance Audit for MySQL?

Remote Login

We access your MySQL server using a secure connection method such as VPN or SSH using access details and credentials you provide.

Hardware Audit

We identify hardware components such as processor make and model, physical memory size and storage type and configuration to determine system capacity limits.

System Audit

We determine the operating system, examine disk partitions and file systems, and check system parameters that may be relevant to MySQL performance.

Utilization Analysis

We evaluate system resources utilisation to verify if the hardware can keep up with the workload demand during peak usage periods

Database Performance

We analyse database operation logs and high-resolution MySQL performance metrics to detect slowdowns, stalls, crashes, and other problems.

Database Configuration

We examine MySQL configuration. It enables us to recommend settings better suited to your environment to ensure the system can perform up to your expectations.

Schema Design and Indexing

We check tables, columns and indexes for best practices and to identify duplicate or ineffective indexes that may be wasting resources.

Slow Query Review

We capture and analyse queries with the highest impact on application performance. Among them, we find opportunities for optimisations or suggest alternatives.

Drafting Report

Following the analysis, we draft a report that highlights all verified or potential problems and provides actionable recommendations you may implement.

Post-Audit Support

You are welcome to follow up with questions or schedule a call with us to discuss the results. We can even help you to implement some of our recommendations from the audit.

Magnifying Glass

Performance Audit

What is the process?
  • 1
    Sign up

    to create a customer account and receive access to our Customer Portal. In the portal, purchase an audit and submit a new audit request.

  • 2
    Set up access

    Set up access to the MySQL server and database for our expert to use during the audit. Create VPN, SSH and MySQL accounts as necessary.

  • 3
    Data collection

    We log in to the server to gather information about hardware and software configurations, and to capture samples of performance data and metrics.

  • 4
    Analysis

    After several days of performance monitoring, the expert analyses information collected from the MySQL server and starts drafting a report.

  • 5
    Report delivery

    The report draft undergoes peer-review and once accepted will be instantly delivered to your email.

Questions? Reach out, and we will be happy to answer them.

Ask Us

Pricing

Performance Audit for MySQL

  •  Health check
  •  Configuration audit
  •  Schema design review
  •  High-impact queries audit
  •  Replication health check
  •  Written audit report
  •  Post-audit support
  •  Initiated within 5 business days
from only
1,299per instance

Frequently Asked Questions

What are the deliverables?

The deliverable is a written report detailing your MySQL server health and performance as well as providing actionable recommendations on how to address identified problems. Additionally, we offer a 14-day post-audit support to help you get the most out of your report.

Will you help me fix the problems you find?

Such help is available through the enhanced post-audit support.

What are the differences between basic and enhanced support?

Both basic support and enhanced support include a call to discuss the audit results as well as a 14-day email support to answer questions about the audit report or our recommendations. The enhanced support additionally includes our assistance in implementing some of the recommendations from the audit (e.g. updating MySQL configuration).

What are the high-impact queries?

A typical MySQL instance runs hundreds or even thousands of different queries every day. However, usually, only a couple dozen are responsible for generating over 99% of database workload and have measurable effects on MySQL performance. They are the ones we find and review during Performance Audit.

Is it available for MariaDB, Percona Server or Amazon RDS?

The audit is compatible with:

  • MySQL
  • MariaDB
  • Percona Server for MySQL
  • MariaDB Galera Cluster
  • Percona XtraDB Cluster

Please if you use a different MySQL engine such as Amazon RDS or Cloud SQL.

Will you need access to my MySQL servers?

Yes. This service requires a remote access to MySQL servers. If you cannot create such access for us, we may be able to help you through On-Demand Consulting or On-Site Consulting. Please contact us for details.

What are the supported connection methods?

In most cases we connect using secure protocols such as SSH or VPN. On your request we may also use applications such as Remote Desktop or TeamViewer.

Audits Compared

Side-by-side comparison to help you choose
  Health Check Configuration Audit Performance Audit
Hardware Assessment
System Capacity Analysis
Performance Analysis Option
Problems Identification Limited Limited
Configuration Tuning
Schema Best Practices
Query Optimisation
Post-Audit Support