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 assessmentTurbocharge MySQL
Fast and reliable databaseGet 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 itAll 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 successWe 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.
Performance Audit
What is the process?- 1
Sign up
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 UsPricing
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
Frequently Asked Questions
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.
Such help is available through the enhanced post-audit 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).
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.
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.
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.
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 |