RE: Query Plan Analyzer

2012-11-26 Thread Rick James
.) -Original Message- From: Cabbar Duzayak [mailto:cab...@gmail.com] Sent: Thursday, November 22, 2012 12:45 AM To: mysql@lists.mysql.com Subject: Re: Query Plan Analyzer Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang zzgang2...@gmail.comwrote: By experience

RE: Query Plan Analyzer

2012-11-22 Thread Zhigang Zhang
By experience! -Original Message- From: Cabbar Duzayak [mailto:cab...@gmail.com] Sent: Thursday, November 22, 2012 3:13 PM To: mysql@lists.mysql.com Subject: Query Plan Analyzer Hi All, Is there a way of looking at how mysql builds the query plan and executes it for a given query?

Re: Query Plan Analyzer

2012-11-22 Thread Cabbar Duzayak
Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang zzgang2...@gmail.comwrote: By experience! -Original Message- From: Cabbar Duzayak [mailto:cab...@gmail.com] Sent: Thursday, November 22, 2012 3:13 PM To: mysql@lists.mysql.com Subject: Query Plan Analyzer Hi All,

Re: Query Plan Analyzer

2012-11-22 Thread Johan De Meersman
- 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