myQueryLogger enables realtime analisys of query traffic. It runs in the background and can capture queries to a log file with user, database info, timestamp. The capture filter can be changed without restarting mysql or the logger by updating cnf file
Be the first to post a text review of myQueryLogger. Rate and review a project by clicking thumbs up or thumbs down in the right column.
I could really use some help ironing out functionality for the next realease of the app. I'm working on a C version that will provide realtime profiling, and the perl version still needs improvement Please send me a message if you're interested in contributing to this project Thank you, Ted
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
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?