by Muhammad Irfan | Sep 14, 2016 | MySQL
Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost....
by Bob Davis | Sep 13, 2016 | MongoDB, MySQL, Percona Software
Percona announces the availability of Percona Monitoring and Management (PMM), an open source software database monitoring and management tool. Completely open source and free to download and use, Percona Monitoring and Management provides point-in-time visibility and...
by Kenny Gryp | Sep 12, 2016 | MySQL, Security
In this blog post, I will discuss the CVE-2016-6662 vulnerability, how to tell if it affects you, and how to prevent the vulnerability from affecting you if you have an older version of MySQL. I’ll also list which MySQL versions include the vulnerability fixes....
by Dave Avery | Sep 12, 2016 | MySQL, Percona Live
Welcome to another Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the...
by Daniel Guzmán Burgos | Sep 9, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes. We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some...
by Sveta Smirnova | Sep 8, 2016 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar. First, I want to thank everybody for attending the August 25 webinar. Below is the list of your questions that I wasn’t able to answer during the webinar, with...
by Miguel Angel Nieto | Sep 2, 2016 | Insight for DBAs, MySQL
by Marco Tusa | Aug 30, 2016 | MySQL
This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s...
by Peter Zaitsev | Aug 25, 2016 | MySQL
Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016. As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused...
by Marco Tusa | Aug 23, 2016 | MySQL, ProxySQL
This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! 😉 But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie,...
by Hrvoje Matijakovic | Aug 23, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current...
by Alexey Stroganov | Aug 22, 2016 | Benchmarks, MySQL
In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance. Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which...
by Muhammad Irfan | Aug 19, 2016 | MySQL, Webinars
Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations”. In this blog, I will provide answers to the Q & A for that webinar. For hardware, which disk raid level do you suggest? Is raid5 suggested...
by Hrvoje Matijakovic | Aug 19, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
by Alexander Rubin | Aug 17, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark. In my previous blog post, I wrote about using Apache Spark with MySQL for data analysis and showed how to transform and analyze a large volume of data (text...
by Vadim Tkachenko | Aug 10, 2016 | Benchmarks, MySQL
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...
by Vadim Tkachenko | Aug 9, 2016 | Benchmarks, MySQL
In this blog post, I’ll discuss changes I’ve made to the tpcc-mysql benchmark tool. These changes make it less random and support multi-schema. This post might only be interesting to performance researchers. The tpcc-mysql benchmark to is what I use to...
by Dave Avery | Aug 9, 2016 | MySQL, Percona Events, Webinars
Join Sveta Smirnova Thursday, August 11 at 10 am PDT (UTC-7) for a webinar on InnoDB Troubleshooting. InnoDB is one of the most popular database engines. This general-purpose storage engine is widely used, has been MySQL’s default engine since version 5.6, and...
by Vadim Tkachenko | Aug 8, 2016 | Cloud, Insight for DBAs, MySQL
In this post, I will point you to Docker images for MySQL Group Replication testing. There is a new release of MySQL Group Replication plugin for MySQL 5.7.14. It’s a “beta” plugin and it is probably the last (or at lease one of the final pre-release...
by Yves Trudeau | Aug 4, 2016 | MySQL, Percona Software
