Accounting for the number of queries in the database

Question

MySQL

Are there such applications that can accurately show how many requests per day were for a particular database? (MySQL example)?

Thanks

Answer 1

data:~# mysqladmin -p status
Uptime: 883938 Threads: 2 Questions: 211385128 Slow queries: 19117 Opens: 7267 Flush tables: 1 Open tables: 2000 Queries per second avg: 239.140

It? The truth here is not per day but per second, well, you can multiply by 60 * 60 * 24

Answer 2

you can turn on the query log in mysql and watch it.

Answer 3

and then there's munin . it turns out very clearly.