EmergencyEMERGENCY? Get 24/7 Help Now!

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

MySQL Webinar: Advanced Query Tuning

 | July 17, 2013 |  Posted In: MySQL, Technical Webinars

On July 24 at 10 a.m. PDT, I will be delivering a Webinar on Advanced MySQL Query Tuning. I will focus on optimizing the common slow queries with group by and order by. Those queries usually create temporary tables and perform a “filesort” operation. I will show how to optimize those queries so that they […]

Read More

MySQL and Hadoop integration

 | July 11, 2013 |  Posted In: Insight for DBAs, MySQL

Dolphin and Elephant: an Introduction This post is intended for MySQL DBAs or Sysadmins who need to start using Apache Hadoop and want to integrate those 2 solutions. In this post I will cover some basic information about the Hadoop, focusing on Hive as well as MySQL and Hadoop/Hive integration. First of all, if you […]

Read More