----- Original Message ----- > From: "Cabbar Duzayak" <cab...@gmail.com> > > 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.
The Percona Toolset has pt-visual-explain and some other useful tools. There's also SHOW PROFILE in mysql itself, look at http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html for more about that. All in all, though, I'm not sure you can go quite as deep as you can in Oracle. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql