From: Cabbar Duzayak
Date: November 22 2012 7:13am
Subject: Query Plan Analyzer
List-Archive: http://lists.mysql.com/mysql/228674
Message-Id:
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=90e6ba6e8b6057250a04cf10339c
--90e6ba6e8b6057250a04cf10339c
Content-Type: text/plain; charset=ISO-8859-1
Hi All,
Is there a way of looking at how mysql builds the query plan and executes
it for a given query? EXPLAIN is definitely a useful tool, but it is not
exact (shows approximations as far as I can see), furthermore I want
something like how the predicates were applied (before or after JOINS),
which indexes were used, etc.
Basically, Oracle's EXPLAIN PLAN and SQL TRACE do this, and it is very very
useful for optimizing queries. Don't get me wrong, I love mysql, but with
mysql, you optimize queries more by trial and error, instead of
understanding what exactly is going on.
Thanks a ton.
--90e6ba6e8b6057250a04cf10339c--