InnoDB

MySQL 5.7 Performance Tuning Immediately After Installation

MySQL 5.7 Performance Tuning

This blog updates Stephane Combaudon’s blog on MySQL performance tuning, and covers MySQL 5.7 performance tuning immediately after installation.
A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation that covers the (now) older versions of MySQL: 5.1, 5.5 and 5.6. In this post, I will look […]

Read more

MySQL 8.0 General Tablespaces: File per Database (and no FRM files)

MySQL 8.0 innodb_dedicated_server

In this blog post, we’ll look at MySQL 8.0 general tablespaces.
Introduction
MySQL 8.0 (the DMR version is available now) has two great features (among others):

The new data dictionary completely removed *.frm files, which is great
The ability to create a tablespace and assign a group of tables to it (originally introduced in 5.7).

With those two options, we […]

Read more

Percona Server 5.5.51-38.2 is now available

percona server for MySQL

Percona announces the release of Percona Server 5.5.51-38.2 on September 21, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.2 is now the current stable release in the 5.5 series.
Percona Server is open-source and free. You can find release details of the release in the 5.5.51-38.2 milestone on Launchpad. […]

Read more

Small innodb_page_size as a performance boost for SSD

performance boost for SSD

In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD.
In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use 4KiB as an internal page size, and the InnoDB default page size is 16KiB. I wondered […]

Read more

Introduction into storage engine troubleshooting: Q & A

Overlooked MySQL performance optimization

In this blog, I will provide answers to the Q & A for the “Introduction into storage engine troubleshooting” webinar.
First, I want to thank everybody for attending the July 14 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer […]

Read more

Percona Server 5.7.13-6 is now available

percona server for MySQL

Percona announces the GA release of Percona Server 5.7.13-6 on July 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.
Based on MySQL 5.7.13, including all the bug fixes in it, Percona Server 5.7.13-6 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

Read more

InnoDB locks and transaction isolation level

Overlooked MySQL performance optimization

What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post.
Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The question:

> I am reading your article:
> https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar
> Full table scan locks […]

Read more

What is a big innodb_log_file_size?

big innodb_log_file_size

In this post, we’ll discuss what constitutes a big
innodb_log_file_size, and how it can affect performance.
In the comments for our post on Percona Server 5.7 performance improvements, someone asked why we use
innodb_log_file_size=10G with an indication that it might be too big?
In my previous post (https://www.percona.com/blog/2016/05/17/mysql-5-7-read-write-benchmarks/), the example used
innodb_log_file_size=15G. Is that too big? Let’s take […]

Read more

Is Adaptive Hash Index in InnoDB right for my workload?

This blog post will discuss what the Adaptive Hash Index in InnoDB is used for, and whether it is a good fit for your workload.
Adaptive Hash Index (AHI) is one of the least understood features in InnoDB. In theory, it magically determines when it is worth supplementing InnoDB B-Tree-based indexes with fast hash lookup […]

Read more

Percona Server 5.7.11-4 is now available

Percona Server

Percona is glad to announce the GA release of Percona Server 5.7.11-4 on March 15, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.
Based on MySQL 5.7.11, including all the bug fixes in it, Percona Server 5.7.11-4 is the current GA release in the Percona Server 5.7 series. All of […]

Read more