How to count number of queries which sent to MySQL database in period of time?

Asked Apr 19 '22 at 10:24

Active Apr 19 '22 at 10:26

Viewed 28 times

Is it possible that can count number of queries which send to the MySQL database, during a specific time?

for example I want to know how many queries was called by using PHP in last month? I know that we can write a program for doing this. foe example by putting this top of a PHP file

show session status like "Queries";

but I want to know does MySQL has this feature? for example a recorded data that counts queries, and when you select a date, it shows number of queries which sent to the MySQL.

edited Apr 19 '22 at 10:26

jarlh

40,041
8
39
58

asked Apr 19 '22 at 10:24

Ali

Does this answer your question? [How to show the last queries executed on MySQL?](https://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql) – Justinas Apr 19 '22 at 10:30
@Justinas you are missing the point OP is asking about count of queries that has been executed over a period of time. – Shoyeb Sheikh Apr 19 '22 at 10:54
You could analyze the mysql logs. – Markus Zeller Apr 19 '22 at 11:53
@ShoyebSheikh No, I don't. There is plenty of answers about where to look for queries logs – Justinas Apr 19 '22 at 21:33

How to count number of queries which sent to MySQL database in period of time?

0 Answers0