1

I'm searching for an Open Source tool to visualise MySQL/MariaDB performance metrics (output of show global status in nice graphs).

In MongoDB world there is the Closed Source Ops Manager and the Open Source mtools. I'm searching for something similar.

In official Oracle training for MySQL 5.6 there are diagrams like

enter image description here

While searching the internet I also found some RRDtool based graphs.

enter image description here

So my question is how to generate ad hoc nice visualisations from MariaDB performance metrics? Is there some Open Source project which helps in this task? How do other DBAs do this?

  • Where did you get those RRDTool based graphs? – Vérace Jul 17 '16 at 14:52
1

There's a lot of choices out there:

Equally capable but not on-premise (afaik) is Vividcortex.

  • 1
    Out of these, only Percona's tools are open-source. (Also, note that MONyog is now (2019) called "SQL Diagnostic Manager for MySQL".) – dbdemon Aug 21 '19 at 11:00
1

Get MonYog through MariaDB. https://www.webyog.com/product/monyog

Note: anything that works with MySQL, MariaDB, or Percona, will probably work well with the others.

I looked at lots of tools, but came away thinking that most graphs were measuring either stuff that never changes. My favorite tool metric is the number of slowlog entries. If that goes up, there are problems. At that point, sometimes the other graphs lead to useful info, but usually fixing a query is the real solution to a performance problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.