You probably want to read this information about MySql's logs. Essentially, MySql will log this data for you and store the logs in the mysqld database directory. Your task, then, is simply to write a log processing script.

Cheers,
Ovid

Join the Perlmonks Setiathome Group or just click on the the link and check out our stats.