Not the answer you need?
Register and ask your own question!

pmm_rep - A script to generate a weekly query analytics email report

archedarched EntrantCurrent User Role Beginner
Hi,

I couldn't find a tool to generate a weekly query analytics email report, when using an on-premises PMM installation.

I then wrote pmm_rep, which fetches data from PMMs qan-api and generates a multipart email report containing last weeks top 10:

https://arch-ed.dk/pmm_query_analytics_reporting
https://github.com/RasmusEdgar/pmm_rep

Perhaps, some of you might find it useful.

Br,
Rasmus Edgar

Comments

  • MykolaMykola Percona Percona Staff Role
    Hi Rasmus,

    Thank you!

    I stared your repo :) also I shared github link internally.
  • archedarched Entrant Current User Role Beginner
    Thank you Mykola.

    Btw, feature and pull requests are welcome. :)
  • archedarched Entrant Current User Role Beginner
    I just wanted to add that the weekly top 10 report is very helpful for spotting tables which need indexing and long queries which need to be investigated. We have optimized several very long running queries the last couple of months because of this. Shameless self bump, I guess, but I genuinely believe that pmm_rep is a helpful addon to PMM for sysadms/dbas.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.