Tag - MySQL Performance Tuning

Compression Options in MySQL (Part 1)

Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like performance of inserts, selects and updates, […]

Read more

Webinar Thu 6/21: How to Analyze and Tune MySQL Queries for Better Performance

database query tuning

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance on Thursday, June 21st, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4).
Register Now
 
Query performance is essential in making any application successful. In order to finely tune your queries you first […]

Read more

Webinar Tues 19/6: MySQL: Scaling and High Availability – Production Experience from the Last Decade(s)

scale high availability

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4).
Register Now
 
Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and executed many […]

Read more

Webinar Weds 6/13: Performance Analysis and Troubleshooting Methodologies for Databases

troubleshooting methodologies

Please join Percona’s CEO, Peter Zaitsev as he presents Performance Analysis and Troubleshooting Methodologies for Databases on Wednesday, June 13th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
Register Now
 
Have you heard about the USE Method (Utilization – Saturation – Errors)? RED (Rate – Errors – Duration), or Golden Signals (Latency – […]

Read more

10 MySQL performance tuning settings after installation

MySQL performance tuning settings

Note: This blog has been updated for MySQL 5.7 here!
In this blog, we’re going to discuss the top ten MySQL performance tuning settings that you can implement after an installation.
When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised […]

Read more