September 2012
M T W T F S S
« Jul   Jul »
 12
3456789
10111213141516
17181920212223
24252627282930

MySQL Visual Explain

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> explain select max(DepDelayMinutes), carrier, dayofweek from ontime.ontime_2010 where dayofweek = 7 group by Carrier, dayofweek\G *************************** 1. row *************************** id: 1 select_type: SIMPLE […]

Speaking at MySQL Connect This Weekend

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 recently and will publish it here. 2. In-Depth Query Optimization for MySQL, where we will work on the real word examples […]