I think it would be nice to have a kind of profiling
support. Sometimes I need to analyse a webscript that
performs multiple database accesses (some very shot,
some a bit longer) when I click on a button.
It would be very usefull to let mtop collect all
databaseactions (or only those based on a regex) for a
certain time (e.g. 5 seconds) and then display them
with some statistics
- how many time this query has been performed during
the time interval.
- Average/Min/Max time spent on this query
- the other stats that are already there :-)
This would allow a quick overview of how efficient
scripts are written (many small accesses, redundant
Perhaps mtop can query the database every 100ms
(adjustable rate) or something (during the
timeinterval), or use a mysql history somewhere if
Keep up the good work!