How to find out how many resources a user used per minute/hour/day in Debian?

Question

MySQL

It is necessary to track the amount of resources consumed by a certain user in Debian per minute/hour/day.
It is necessary to have indications on the following resources:
1. How much processor the user ate
2. How much traffic the user ate
3. How much traffic he drove between php and mysql the user
4. Number of select/insert/update/delete/alter requests for the user
5. Number -number of requests to get static files (nginx)
6. Number of requests that came to php (apache2)
Kick in the right direction.
PS. According to points 5 and 6, it is clear that you need to parse logs, but how to parse them, say, for a period of 1 hour?

Answer 1

Zabbix will help you, everything will be clear, in graphs, for any period of time

Answer 2

There are many options:
- zabbix (as already written above - I support)
- munin (graphics)
- collectd + graphite ( here is an article)
- bash scripts of their own execution))