Menu

Initial Release

The initial release contains a working version of the query logger that has been tested with over 3000 queries per second on a real production system. It's been running on this machine for a few months, logging a certain set of queries to a small log file

A busy instance can generate hundreds of gigabytes in query logs per day and typical query logging usually impacts performance since the server needs to write to disk for any query it encounters

This utility allows for continuous or occasional monitoring of mysql without the need to restart mysql to enable and disable query logging. The processing is lightweight and logging to a ram buffer doesn't create performance problems introduced by typical query logging

This script can log only queries that a user cares about, which significantly reduces the size of the log

Posted by Teddy 2007-05-19

Log in to post a comment.

MongoDB Logo MongoDB