Total number of read/writes in a day in MySQL Aside from using standard count queries with a date, is there a global way to get the number of writes (or reads for that matter) in a 24hr period on a table, or an entire schema?
If you have binary logging enabled, you can analyse your binlogs to identify types and number of statements executed.

mysqlbinlog your_binlog | grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | cut -c1-100 | tr '[A-Z]' '[a-z]' | sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" | sort | uniq -c | sort -nr


You might need --base64-output=DECODE_ROWS for row based binlog format.
You can analyze your day worth of binlogs or use --start/--end options to select time.

Check out this and this blog posts.