Buy Percona ServicesBuy Now!

MySQL Audit Plugin now available in Percona Server 5.5 and 5.6

 | May 7, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server for MySQL, Percona Software

The new Percona Server 5.5.37-35.0 and Percona Server 5.6.17-65.0-56, announced yesterday (May 6), both include the open source version of the MySQL Audit Plugin. The MySQL Audit Plugin is used to log all queries or connections (“audit” MySQL usage). Until yesterday’s release, the MySQL Audit Plugin was only available in MySQL Enterprise. EDIT:  Just to be clear, this implementation […]

Read More

Creating GEO-enabled applications with MySQL 5.6

 | March 24, 2014 |  Posted In: MySQL, Percona Live

In my previous post I’ve showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post I will show how we can obtain open-source GIS data, convert it to MySQL and use it in our GEO-enabled applications. I will also present at the upcoming Percona Live conference on this […]

Read More

Increasing slow query performance with the parallel query execution

 | January 7, 2014 |  Posted In: MySQL

MySQL and Scaling-up (using more powerful hardware) was always a hot topic. Originally MySQL did not scale well with multiple CPUs; there were times when InnoDB performed poorer with more  CPU cores than with less CPU cores. MySQL 5.6 can scale significantly better; however there is still 1 big limitation: 1 SQL query will eventually use only […]

Read More

Linux performance tuning tips for MySQL

 | December 7, 2013 |  Posted In: MySQL

Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post. Filesystem ext4 (or xfs), mount with […]

Read More

New MySQL features, related technologies at Percona Live London

 | October 23, 2013 |  Posted In: Events and Announcements, MySQL, Percona Live

The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features: Opening keynote highlights MySQL 5.6 new features. New InnoDB Compression talk will cover the new compression algorithm, implemented by Facebook and […]

Read More

MySQL Spatial Functions for Geo-Enabled Applications

 | October 21, 2013 |  Posted In: MySQL

Geo-enabled (or location enabled) applications are very common nowadays and many of them use MySQL spatial functions. The common tasks for such applications are: Find all points of interests (i.e. coffee shops) around (i.e. a 10 mile radius) the given location (latitude and longitude). For example we want to show this to a user of […]

Read More

Join my Oct. 2 webinar: ‘Implementing MySQL and Hadoop for Big Data’

 | October 1, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars

MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with Apache Hadoop and MySQL. This […]

Read More

Big Data with MySQL and Hadoop at MySQL Connect 2013

 | August 8, 2013 |  Posted In: MySQL

I will be talking about Big Data with MySQL and Hadoop at MySQL Connect 2013 (Sept. 21-22) in San Francisco as well as at Percona University at Washington, DC (September 12, 2013). Apache Hadoop is a very popular Big Data solution and we can nowadays easily integrate it with MySQL. I will start with a brief introduction […]

Read More