This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit tools.
Have you ever had a problem understanding the EXPLAIN statement output? And are you the type of person who would rather use the command line than a GUI application? Then I would recommend that you use Percona’s pt-visual-explain toolkit. This is one of many Percona Toolkit tools that is useful for those who want to have a different view and an easier time understanding the EXPLAIN output aside from the usual table and vertical views.
As described in the documentation – http://www.percona.com/doc/percona-toolkit/2.2/pt-visual-explain.html#description
“pt-visual-explain reverse-engineers …[Read more]