Best way to get database table statistics such as records added per hour.
I am interested in getting database table statistics to get an idea of how many records are being added to a table every hour. I could setup a database trigger and compile my own totals everytime a record is added. I am wondering if there is a built in utility for compiling database statistics with mysql.
I'd like to take a table and have a number for hourly average number of records added to the db. Or daily number or records added to the table.