MySQL explain extended
User:
mcholste
Date: 6/17/2010 12:40 am
Date: 6/17/2010 12:40 am
Views: 326
Rating: 0
Rating: 0
At last night's meeting there was some commiserating regarding
weirdnesses with MySQL's optimization choices. Percona just had an
interesting blog post which discusses using the EXPLAIN EXTENDED
command, which I didn't know about (the extended version, that is)
here: http://www.mysqlperformanceblog.com/2010/06/15/explain-extended-can-tell-you-all-kinds-of-interesting-things/
. Looks like it could be very useful as it shows the actual query
plan with optimizations, etc.
--Martin
weirdnesses with MySQL's optimization choices. Percona just had an
interesting blog post which discusses using the EXPLAIN EXTENDED
command, which I didn't know about (the extended version, that is)
here: http://www.mysqlperformanceblog.com/2010/06/15/explain-extended-can-tell-you-all-kinds-of-interesting-things/
. Looks like it could be very useful as it shows the actual query
plan with optimizations, etc.
--Martin