
derived - run command periodically and calculate rate and check from network

$ cat CmdsFile slowqueries: mysql -NB -e 'show global status like "Slow_queries%"' $ derived --port 12306 CmdsFile $ telnet localhost 12306 get slowqueris VALUE slowqueris 0 3 0.2 # slow queries/sec

derived runs command periodically and capture integer value. And calculate per-second rate. You can retrieve these values from integrated memcached-protocol server
You can monitoring the variation of metrics through this daemon.

Display help message
Interval seconds for running commands. Default 10.
Port number to bind
IP address to bind

A command file should contain both a name for the process and the command used to run it.
slowquery: mysql -NB -e 'show global status like "Slow_queries%"' lines: wc -l /path/to/file

You can access to data via integrated memcached-protocol server.
use Cache::Memcached::Fast;
my $memcached = Cache::Memcached::Fast->new({
servers => [qw/localhost:12306/],
});
say $memcached->get('slowqueris'); # only per seconds value.
say $memcached->get('slowqueris:latest'); # only latest value.
say $memcached->get('slowqueris:full'); #JSON formated data include raw values

IF there is no previous data to calculate rate, the server returns "0E0"

Masahiro Nagano <kazeburo@gmail.com>

Copyright (C) Masahiro Nagano
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.