Fluent input plugin for MySQL slow query log file.
#2 Compare This branch is 20 commits behind yuku-t:master.
Latest commit 12b80f9 Jun 7, 2012 @yuku-t yuku-t update README
Permalink
Failed to load latest commit information.
lib/fluent/plugin use myslog Jun 7, 2012
.gitignore add gitignore Jun 5, 2012
Gemfile add Gemfile Jun 7, 2012
README.md update README Jun 7, 2012
Rakefile add gemspec Jun 5, 2012
fluent-plugin-mysqlslowquery.gemspec v0.0.2 Jun 7, 2012

README.md

fluent-plugin-mysqlslowquery

Fluent input plugin for MySQL slow query log file.

Installation

% gem install fluent-plugin-mysqlslowquery

How to use

Edit conf file.

#/etc/fluentd/fluent.conf
<source>
  type mysql_slow_query
  path /path/to/mysqld-slow.log
  tag mysqld.slow_query
</source>

Expected record format

Sample

# Time: 111003 14:17:38
# User@Host: root[root] @ localhost []
# Query_time: 0.000270  Lock_time: 0.000097 Rows_sent: 1  Rows_examined: 0
SET timestamp=1317619058;
SELECT * FROM life;

Record

{
    "user": "root[root]",
    "host": "localhost",
    "host_ip": "",
    "query_time": 0.000270,
    "lock_time": 0.000097,
    "rows_sent": 1,
    "rows_examined": 0,
    "sql": "SET timestamp=1317619058; SELECT * FROM life;"
}