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 Hrvoje Matijakovic | Aug 22, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.32-78.0 on August 22nd, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.32, including all the bug fixes in it, Percona Server 5.6.32-78.0 is the...
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 Vadim Tkachenko | Aug 18, 2016 | MySQL
The GA release of ProxySQL 1.2.1 is available. You can get it from https://github.com/sysown/proxysql/releases. There are also Docker images for Release 1.2.1: https://hub.docker.com/r/percona/proxysql/. ProxySQL is a high-performance proxy, currently for MySQL and...
by George O. Lorch III | Aug 17, 2016 | MySQL
In this blog post, we’ll discuss how we’ve improved TokuDB and PerconaFT fragmented data file performance. Through our internal benchmarking and some user reports, we have found that with long term heavy write use TokuDB/PerconaFT performance can degrade...
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 Dave Avery | Aug 16, 2016 | MySQL
Join Percona’s Jervin Real for a webinar on Thursday August 18, 2016 at 10 am PDT (UTC-7) on Preventing and Resolving MySQL Downtime. Preventing MySQL downtime and emergencies is difficult. Often complex combinations of several things going wrong cause these...
by Hrvoje Matijakovic | Aug 16, 2016 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.19. Released August 16, 2016. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL server and system tasks that DBAs find too difficult or complex for to...
by Colin Charles | Aug 16, 2016 | MongoDB, MySQL, Percona Events
Let me introduce myself, I’m Colin Charles. Percona turns ten years old this year. To me, there is no better time to join the company as the Chief Evangelist in the CTO office. I’ve been in the MySQL world a tad longer than Percona has, and have had the pleasure...
by Kortney Runyan | Aug 15, 2016 | MySQL
This post reveals the full Percona Live Europe 2016 schedule for Amsterdam this October 3-5. The official The Percona Live Open Source Database Conference Europe 2016 schedule is now live, and you can find it here. The schedule demonstrates that this conference has...
by Tim Vaillancourt | Aug 12, 2016 | MongoDB
In this post, we’ll discuss tuning Linux for MongoDB deployments. By far the most common operating system you’ll see MongoDB running on is Linux 2.6 and 3.x. Linux flavors such as CentOS and Debian do a fantastic job of being a stable, general-purpose...
by Alexey Zhebel | Aug 11, 2016 | MySQL, Percona Events, Percona Software
Percona announces the first release candidate (RC1) in the Percona XtraDB Cluster 5.7 series on August 9, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.7.12-5rc1-26.16 is based on the following: Percona...
by Denis Protivenskii | Aug 11, 2016 | Benchmarks, MongoDB
This post discusses Percona Server for MongoDB’s new in-memory storage engine, Percona Memory Engine for MongoDB. Percona Server for MongoDB introduced the Memory Engine starting with the 3.2.8-2.0 version. To use it, run Percona Server for MongoDB with the...
by Alexey Zhebel | Aug 11, 2016 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.8-2.0 on August 11, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.2.8-2.0 is an enhanced, open-source, fully compatible,...
by Peter Zaitsev | Aug 11, 2016 | MongoDB, Percona Events
I’m pleased to announce the latest Percona Server for MongoDB feature: Percona Memory Engine for MongoDB. Everybody understands that memory is much faster than disk – even the fastest solid state storage can’t compete with it. As such the choice for the most...
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...
