Link to home
Start Free TrialLog in
Avatar of parlays
parlays

asked on

Best way to get database table statistics such as records added per hour.

Hello!

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.

thanks!
ASKER CERTIFIED SOLUTION
Avatar of maeltar
maeltar
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial