Author - Alexander Rubin

MySQL Webinar: Advanced Query Tuning

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 […]

Read more

MySQL and Hadoop Integration

Dolphin and Elephant: an Introduction
This post is intended for MySQL DBAs or Sysadmins who need to start usinginstalling and configuring Hadoop is to implement a data flow between Hadoop and MySQL. If you have an OLTP system based on MySQL and you will want to use Hadoop for data analysis (data science) you may […]

Read more