How to determine MySQL queries per day?
For SELECTs:

show global status like "Com_select";


UPDATEs:

show global status like "Com_update";


INSERTs: 

show global status like "Com_insert";


DELETEs:

show global status like "Com_delete";


ALl values are "cumulativ" since MySQL last restart.

So to get your SELECTs in one hour:

At 9pm:

[21:00:00] [DEV\(none)] mysql&gt; show global status like "Com_select";
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| Com_select    | 671664 |
+---------------+--------+
1 row in set (0.00 sec)


At 10pm:

[22:00:00] [DEV\(none)] mysql&gt; show global status like "Com_select";
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| Com_select    | 672363 |
+---------------+--------+
1 row in set (0.00 sec)


The number of SELECT in the past hour : 672363 - 671664 = 699

Best Regards