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


http://www.host7x.com/myQueryLogger





Separate each tag with a space.

Release Date:

2007-05-19

Topics:

License:

Ratings and Reviews

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.

Project Feed

  • Developers Wanted! (Perl and C)

    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

    posted by teddy7x 904 days ago

  • 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 teddy7x 904 days ago

  • myquerylogger v1.0.0a file released: myQueryLogger.zip

    posted 904 days ago

  • File released: /myquerylogger/v1.0.0a/myQueryLogger.zip

    posted 904 days ago

Rate and Review

Be the first person to add a text review.

Would you recommend this project?






<

Related Projects

myQueryLogger Actions

Thanks for your rating!

Would you also like to write a review?





Skip Review