Monthly Archives - May 2016

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

Galera Error Failed to Report Last Committed (Interrupted System Call)

In this blog, we’ll discuss the ramifications of the Galera Error Failed to Report Last Committed (Interrupted System Call).
I have recently seen this error with Percona XtraDB Cluster (or Galera):
[Warning] WSREP: Failed to report last committed 549684236, -4 (Interrupted system call)
It was posted in launchpad as a bug in 2013: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1434646
My colleague Przemek replied, […]

Read more

Asynchronous Query Execution with MySQL 5.7 X Plugin

In this blog, we will discuss MySQL 5.7 asynchronous query execution using the X Plugin.
Overview
MySQL 5.7 supports X Plugin / X Protocol, which allows (if the library supports it) asynchronous query execution. In 2014, I published a blog on how to increase a slow query performance with the parallel query execution. There, I created a prototype in […]

Read more

Monitoring made easy with Percona App for Grafana

Percona has released a new Percona App for Grafana!
Are you using Grafana 3.x with Prometheus’ time-series database? Now there is a “Percona App” available on Grafana.net! The app provides a set of dashboards for MySQL performance and system monitoring with Prometheus’ datasource, and make it easy for users install them. The dashboards rely on the alias label […]

Read more

AWS Aurora Benchmarking part 2

Some time ago, I published the article on AWS Aurora Benchmarking (AWS Aurora Benchmarking – Blast or Splash?), in which I analyzed the behavior of different solutions using synchronous replication in AWS environment. This blog follows up with some of the comments and suggestions I received regarding that post from the community and Amazon […]

Read more

MongoDB 3.2: elections just got better!

Introduction
In this blog, we’ll review MongoDB 3.2 elections and how they work, as well as what is really new and different in the election protocol.
MongoDB 3.2 revamped its election protocol for increased stability! Exciting times, with smarter and faster elections are here! With this latest release, you will find that replication (and the election […]

Read more

Percona Server 5.6.30-76.3 is now available

percona server for MySQL

Percona is glad to announce the release of Percona Server 5.6.30-76.3 on May 25, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.
Based on MySQL 5.6.30, including all the bug fixes in it, Percona Server 5.6.30-76.3 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Read more

Looking inside the MySQL 5.7 document store

tpcc-mysql benchmark

In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented.
Document Store
MySQL 5.7.12 is a major new release, as it contains quite a number of new features:

Document store and “MongoDB” like NoSQL interface to JSON storage
Protocol X / X Plugin, which can be used for asynchronous queries (I will […]

Read more