'logs' Tag

  • oak-hook-general-log: your poor man's Query Analyzer

    December 15, 2010

    The latest release of openark kit introduces oak-hook-general-log, a handy tool which allows for some analysis of executing queries. Initially I just intended for the tool to be able to dump the general log to standard output, from any machine capable to connect to MySQL. Quick enough, I realized the power it brings. With this […]

  • EXPLAIN: missing db info

    May 11, 2010

    I'm further developing a general log hook, which can stream queries from the general log. A particular direction I'm taking is to filter queries by their type of actions. For example, the tool (oak-hook-general-log) can be instructed to only stream out those queries which involve creation of a temporary table; or those which cause for […]

  • oak-hook-general-log: streaming general log

    March 21, 2010

    I'm seeking input on a new openark kit utility I've started to implement. The tool, oak-hook-general-log, will hook up to a MySQL (>= 5.1) server, and stream the general log into standard output. It looks like this: bash$ python src/oak/oak-hook-general-log.py --socket=/tmp/mysql.sock --user=root 2010-03-21 10:18:42     root[root] @ localhost []       79      1       Query   SELECT COUNT(*) FROM City […]

 
Powered by Wordpress and MySQL. Theme by openark.org