Many customers are asking for getting stats from their MySQL installation. It’s pretty easy to find stats per database from Com_ variables and graph them as counter to get the number of INSERT/UPDATE/DELETE on the database level. To get the DML stats from MySQL at table level there is only one option : mysqlbinlog . Here is the best post I found that can help you to answer your question.
Get the MySQL table stats now!
It’s free seminar for full day on MySQL for Oracle DBA!!
Check it out on MySql website to free registration.
Location and details:
Date: Tues Aug 14, 2007
The Westin New York at Times Square
270 West 43rd Street
New York, NY 10036
I am going to attend . If you are , see you there!!