It is time for the Query Tuning Webinar again! This year I will be delivering the Webinar on July 24 at 10 a.m. PDT, Advanced MySQL Query Tuning, hosted by Percona. I have included some new topic...
http://www.arubin.org/blog/2013/07/19/new-upcoming-webinar-advanced-query-tuning/
If you are tied of reading the old “text-only” output of MySQL Explain, then you will enjoy the new MySQL Visual Explain feature of MySQL Workbench (works with MySQL 5.6+). Before: mysql> e...
I will give 2 talks at MySQL Connect 1. New MySQL Full-Text Search Features and Solutions, where I will focus on the new (and very promising!) InnoDB full text search. I’ve done some benchmarks...
http://www.arubin.org/blog/2012/09/24/speaking-at-mysql-connect-this-weekend/
MySQL Enterprise 5.5 (trial version available here) includes MySQL PAM authentication plugin. In this post I will show how to configure it with the OpenLDAP and Active Directory. MySQL PAM auth...
http://www.arubin.org/blog/2012/07/16/mysql-pam-ldap-authentication-module-configuration/
In my previous post, I’ve showed how to use Dtrace to find queries creating disk temporary tables (only available for OS with dtrace: solaris, freebsd, etc). In MySQL 5.6 (which is not releas...
With the standard data warehousing queries we have a fact table and dimension tables and we join them. For example, the fact table (Table size: 5M rows, ~2G in size) from my previous Loose index ...
http://www.arubin.org/blog/2010/11/29/fixing-data-warehousing-queries-with-group-by/
Lets say we have a table storing mail messages and we need to show user’s mailbox: messages sent “from” and “to” the specified user. Here is our table: CREATE TABLE `internalmail` ( `...
http://www.arubin.org/blog/2010/11/22/converting-queries-with-or-to-union-to-ulitize-indexes/
Loose index scan in MySQL can really help optimizing “group by” queries in some cases (for example, if you have only min() and/or max() as your aggregate functions). For example, if you have ...
http://www.arubin.org/blog/2010/11/18/loose-index-scan-vs-covered-indexes-in-mysql/
First of all: mysqldump is not converting tables. It is something else. Here is the story: One of my clients had a case when they were migrating to a new mysql server: they used mysqldump to ex...
http://www.arubin.org/blog/2010/11/12/why-mysqldump-is-converting-my-tables-from-innodb-to-myisam/
I’ll be speaking on MySQL Users Conference 2010. Talk: MySQL Architecture Design Patterns for Performance, Scalability, and Availability, 11:55am Thursday, 04/15/2010. Details.
http://www.arubin.org/blog/2010/04/10/speaking-at-mysql-users-conference-and-expo-2010/