Is there a system/tool that considers daily/weekly/monthly statistics for the SQL sensors?

Tell me, please, does the nature of any online service (or a downloadable set of scripts) that is able to build statistics of key indicators (number of registrations, number of important operations, etc.) on the database, not only daily, but monthly, daily and send to mail something like this?



(NOTE: all names in the screenshot I wrote "from the bulldozer", there is no sense in them do not look for — in particular, it does NOT log data, i.e. it is sought NOT system log analysis, and system that can at night to count the statistics on the real database.)

In this screenshot:
1. Each row formed a separate SQL query, which you can edit at any time, to convert, test, etc.
2. SQL queries natravlyayut to the main database (or replica) of the project, i.e. daily consider main indicators of the project.
3. When you run a SQL query for a particular cell in a particular row receives the macros "to consider starting timestamp and ending timestamp to count th".
4. All these queries are run at night (since they can be slow), the result is stored and then drawn when needed.

Who than uses in my projects?
How anyone keeps track of key performance indicators?
October 3rd 19 at 04:36
3 answers
October 3rd 19 at 04:38
To test for example phpmyadmin, and collect for example in zabbix, with graphs and everything.
Only there is one problem — then if there is an error in the query (after a couple of weeks), Zabbix will not give in the past to convert graphics. Plus it doesn't show monthly/quarterly aggregation (for example, the number of unique emails in the system for a month is equal to the sum of the number of unique emails for 30 days). - orlando.Bode8 commented on October 3rd 19 at 04:41
And here and there. All he would give to correct, if you count the figures.
1) to Stop collecting data in Zabbix
2) Flush the data at atemu in Zabbix
3) Conversion rates "the correct query"
4) - Ing array data timestampe in Zabbix through a zabbix trapper

As for the aggregations and other nishtyakov — yuzayte Google Charts or any other chart-analogues. We used uglovye charts. Generate array of data given to draw a pretty picture, according to the requirements. And privacity it can be the same screen in Zabbix. - teresa83 commented on October 3rd 19 at 04:44
October 3rd 19 at 04:40
I would have picked at GoogleAnalytics — a large part of what is drawn in the table is in their web interface.
Some events will have handles to hang the triggers that via JS API to notify about these events GA.
They can through the API to get data for some specific tasks/calculations
--del-- - orlando.Bode8 commented on October 3rd 19 at 04:43
October 3rd 19 at 04:42
GoogleAnalytics either it is an opensource analog of Piwik, so for me a more appropriate API, for example out of the box there is a class for php

use it to track calls to its API. The Dashboard is completely custom, the user access control... Yet performs its functions, it is easier than GA thought
And how exactly do you use it for tracking, can you write? For each query pull api on the side of piwik? Or feed him logs? Climbs or piwik directly in the database and takes out the data? How does it work? - orlando.Bode8 commented on October 3rd 19 at 04:45
twitch API pivica

on topic, IMHO the finished projects such hardly exist, because the database specific to each project work, respectively, and to work with them need specific. - teresa83 commented on October 3rd 19 at 04:48

Find more questions by tags Analyst