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

column compression

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

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