Collecting php, mysql statistics?

Question

Monitoring

How to correctly implement the collection of statistics in the database? What stacks and technologies are better to use for this?
Let's say now the collection of statistics is going to the database, then it draws graphics on js (with each render it accesses the database), but this is not quite the right approach, it seems to me ...

Answer 1

Use Prometheus+Grafana or Zabbix.
Prometheus can collect millions of metrics per minute.