EmergencyEMERGENCY? Get 24/7 Help Now!

Best Practices for Configuring Optimal MySQL Memory Usage

 | May 3, 2016 |  Posted In: MySQL

Optimal MySQL Memory Usage

In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage. Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of […]

Read More

MySQL Document Store Developments

 | April 15, 2016 |  Posted In: MySQL

MySQL Document Store

This blog will discuss some recent developments with MySQL document store. Starting MySQL 5.7.12, MySQL can be used as a real document store. This is great news! In this blog post, I am going to look into the history-making MySQL work better for “NoSQL” workloads and more of the details on what MySQL document store offers […]

Read More

Evaluating Database Compression Methods: Update

and  | April 13, 2016 |  Posted In: Benchmarks, MySQL

Database Compression Methods

This blog post is an update to our last post discussing database compression methods, and how they stack up against each other.  When Vadim and I wrote about Evaluating Database Compression Methods last month, we claimed that evaluating database compression algorithms was easy these days because there are ready-to-use benchmark suites such as lzbench. As […]

Read More

TokuDB impacts InnoDB Performance?

 | March 22, 2016 |  Posted In: MySQL

TokuDB impacts InnoDB performance

This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment. You would think MySQL storage engines are fairly independent of each other, even in the same environment. Enabling one, or changing its configuration, logically should have no impact on the performance of other engines (such as InnoDB) when they […]

Read More

Finding MySQL Table Size on Disk

 | January 26, 2016 |  Posted In: MySQL

MySQL table size

So you want to know how much space a given MySQL table takes on disk. Looks trivial, right? Shouldn’t this information be readily available in the INFORMATION_SCHEMA.TABLES? Not so fast! This simple question actually is quite complicated in MySQL. MySQL supports many storage engines (some of which don’t store data on disk at all) and […]

Read More

Prometheus as an Engine for MySQL Monitoring

 | January 14, 2016 |  Posted In: Prometheus

When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities.  Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, allowing you to do all kinds of math and transformations while visualizing data. For example, I could plot the relationship […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.