Buy Percona ServicesBuy Now!

Chunk Change: InnoDB Buffer Pool Resizing

 | June 19, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

innodb buffer pool chunk size

Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. […]

Read More

Using Hints to Analyze Queries

 | April 17, 2018 |  Posted In: MySQL

Hints to Analyze Queries

In this blog post, we’ll look at using hints to analyze queries. There are a lot of things that you can do wrong when writing a query, which means that there a lot of things that you can do to make it better. From my personal experience there are two things you should review first: The table […]

Read More

Generated Columns and ProxySQL Instead of Referenced Tables

 | January 2, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, ProxySQL

Generated Columns

In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table. Developers and architects don’t always have the time or complete information to properly analyze and design a database. That is why we see tables with more fields than needed, or with incorrect types. The […]

Read More

Storing UUID and Generated Columns

 | May 3, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Storing UUID

A lot of things have been said about UUID, and storing UUID in an optimized way. Now that we have generated columns, we can store the decomposed information inside the UUID and merge it again with generated columns. This blog post demonstrates this process. First, I used a simple table with one char field that I called […]

Read More

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

 | October 21, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster nodes (mostly configured as default), copied from a production server. We […]

Read More

Speed up GROUP BY queries with subselects in MySQL

 | June 15, 2015 |  Posted In: MySQL

We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect? This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5 and 5.6. Let’s […]

Read More