by Vadim Tkachenko | Jun 7, 2016 | MySQL
In this post, we’ll discuss some insight I’ve gained regarding severe performance regression in MySQL 5.7 crash recovery. Working on different InnoDB log file sizes in my previous post:...
by Dave Avery | Jun 6, 2016 | MySQL
Please join us on Thursday June 9, at 10:00 am PDT (UTC-7) for the webinar Troubleshooting MySQL configuration issues. MySQL Server is highly tunable. It has hundreds of configuration options which provide great tuning abilities and, at the same time, can be...
by Hrvoje Matijakovic | Jun 6, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the GA release of Percona Server 5.7.12-5 on June 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.12, including all the bug fixes in it, Percona Server 5.7.12-5 is...
by David Busby | Jun 6, 2016 | MySQL
We have had to revert back to TLSv1.0. If you saw my previous post on TLSv1.0 (https://www.percona.com/blog/2016/05/23/percona-disabling-tlsv1-0-may-31st-2016/), you’ll know I wanted to deprecate TLSv1.0 well ahead of PCI’s changes. We made the...
by Alexey Zhebel | Jun 3, 2016 | MongoDB, Percona Events, Percona Software
Percona is pleased to announce the release of Percona Server for MongoDB 3.2.6-1.0 on June 3, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.2.6-1.0 is an enhanced, open-source, fully...
by Roel Van de Paar | Jun 3, 2016 | MySQL
Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings. Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511...
by Manjot Singh | Jun 2, 2016 | Percona Software
In this post, we’ll discuss the Galera warning “last inactive check” and what it means. Problem I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today:...
by Kortney Runyan | Jun 2, 2016 | Percona Live
The Percona Live Europe 2016 call for papers is now officially open! We’re looking forward to seeing you in Amsterdam this October 3-5, and hearing your speak! Ask yourself “Do I have…”: Fresh ideas? Enlightening case studies? Insight on best practices? In-depth...
by Peter Zaitsev | Jun 1, 2016 | MySQL
In this blog, we’ll use some test results to look at the rationale for using provisioned IOPS volumes for AWS databases. One piece of advice you often hear running MySQL, MongoDB or other databases in the AWS EC2 environment is that you should use volumes with...
by Alexander Rubin | Jun 1, 2016 | MongoDB, MySQL
by Peter Zaitsev | Jun 1, 2016 | MongoDB
This blog post discusses Percona’s future plans for TokuMX, PerconaFT, and MongoRocks for MongoDB 3.2 and later releases. At Percona, we focus on providing the best solution for our customers, rather than falling into “big ego,” “not invented here” or “sunk cost...
by Sveta Smirnova | May 31, 2016 | MySQL
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...
by Vadim Tkachenko | May 31, 2016 | MySQL
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...
by Manjot Singh | May 27, 2016 | MySQL, Percona Software
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...
by Alexander Rubin | May 27, 2016 | MySQL
by Peter Zaitsev | May 27, 2016 | MongoDB, Percona Events
If you can make it to Manhattan Thursday, June 30, 2016, please join me at the Community Open House for MongoDB. The Community Open House for MongoDB, held from 9 AM to 6 PM at the Park Central Hotel, is a free and open event that will feature technical presentations...
by Roman Vynar | May 26, 2016 | 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...
by Marco Tusa | May 26, 2016 | 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...
by David Murphy | May 25, 2016 | 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...
by Hrvoje Matijakovic | May 25, 2016 | MySQL, Percona Events, Percona Software
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...