Monthly Archives - August 2016

Top Most Overlooked MySQL Performance Optimizations: Q & A

Overlooked MySQL performance optimization

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 performance-wise and data-integrity-wise?
RAID 5 comes with high overhead, as each write turns […]

Read more

Percona Server 5.5.51-38.1 is now available

percona server for MySQL

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 find release details of the release in the 5.5.51-38.1 milestone on Launchpad. […]

Read more

ProxySQL 1.2.1 GA Release

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 its forks (like Percona Server and MariaDB). It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for DBAs by […]

Read more

TokuDB/PerconaFT fragmented data file performance improvements

fragmented data file performance

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 significantly on large data files. Using smaller node sizes makes the problem worse (which is one of […]

Read more

How Apache Spark makes your slow MySQL queries 10x faster (or more)

Slow MySQL Queries

In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark.
Introduction
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 files) with Apache Spark. Vadim also performed a benchmark […]

Read more

Webinar Thursday 8/18: Preventing and Resolving MySQL Downtime

PMM

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 emergencies. Without knowledge of the causes of emergencies, preventative proactive measures often fail to prevent further […]

Read more

Percona Toolkit 2.2.19 is now available

Percona Toolkit

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 perform manually. Percona Toolkit, like all Percona software, is free and open source.
This release […]

Read more

I’m Colin Charles, and I’m here to evangelize open source databases!

Colin Charles

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 of working on MySQL at […]

Read more

Percona Live Europe 2016 Schedule Now Live

Percona Live Europe

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 something for everyone! Whether your interest is in MySQL, MongoDB or other open […]

Read more

Tuning Linux for MongoDB

tuning Linux for 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 operating system. Linux runs software on hardware ranging from tiny computers like the […]

Read more