Tim Moores wrote:You could also look into a logging jdbc driver like p6spy. I don't know if it can log the duration of a query, though.
Some DBs can do this, too. MySQL, for example, can log all queries that take longer than a configurable number of seconds.
Any other thoughts or suggestions in regards to logging process times when logging to a database server?
Erek Wright wrote:Hello, we are attempting to implement access logging to a mysql database and are successfully logging the default patterns using the jdbcaccesslogvalve.