EmergencyEMERGENCY? Get 24/7 Help Now!

Troubleshooting locking issues webinar: Q & A

 | May 31, 2016 |  Posted In: MySQL

Overlooked MySQL performance optimization

In this blog, I will provide answers to the Q & A for the Troubleshooting locking issues webinar. First, I want to thank you for attending the May, 12 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 during the webinar, […]

Read More

What is a big innodb_log_file_size?

 | May 31, 2016 |  Posted In: InnoDB, MySQL

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 […]

Read More

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

 | May 27, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

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 […]

Read More

Asynchronous Query Execution with MySQL 5.7 X Plugin

 | May 27, 2016 |  Posted In: MySQL

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 […]

Read More

Monitoring made easy with Percona App for Grafana

 | May 26, 2016 |  Posted In: Database Monitoring

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

 | May 26, 2016 |  Posted In: MySQL

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 engineers. […]

Read More

MongoDB 3.2: elections just got better!

 | May 25, 2016 |  Posted In: MongoDB

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 […]

Read More

Percona Server 5.6.30-76.3 is now available

 | May 25, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

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

 | May 24, 2016 |  Posted In: MySQL

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 […]

Read More