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?
(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?
asked October 3rd 19 at 04:36
3 answers
answered on October 3rd 19 at 04:38
To test for example phpmyadmin, and collect for example in zabbix, with graphs and everything.
answered on 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
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-- commented on October 3rd 19 at 04:43
answered on 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
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? 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. commented on October 3rd 19 at 04:48
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. commented on October 3rd 19 at 04:48
Find more questions by tags Analyst
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