November 22, 2014

Tools to use for MySQL Performance Review

There are some tools we commonly use doing performance review and optimization and we often ask each other where that particular stuff is located on the web or what is exactly name of the command what does that.

Initially I thought creating internal Percona Wiki page, but thought there is no reason this information should not be public instead.

So now you can find our favorite MySQL Performance Review Tools on the site.

This is just list of tools which came from the top of my head and I’m sure it is far from complete. We will extend it and we would like to hear your suggestions on what else we should add to it.

In this list we focused on Open Source tools which are helpful for “in time” performance audit – for example you see no graphing software in this list or any commercial offerings.

About Peter Zaitsev

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

Comments

  1. Why not create this page on the Forge wiki, so others can update, collaborate on, etc. ?

  2. peter says:

    I do not mind if same page created (or this page copied for the start)

    Regarding this page I want to keep it containing only tools We consider worthwhile.

    There are literally hundreds of MySQL tools out where (the whole Forge is) – this is however list of tools which We used and consider useful.

  3. Darius says:

    We used to utilize innotop for my MySQL tool. That was great tool ever I had for MySQL performance and optimization tasks. It is worth to benchmark to other tools as well if needed.

Speak Your Mind

*