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: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.
To install App::derived, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::derived
CPAN shell
perl -MCPAN -e shell install App::derived
For more information on module installation, please visit the detailed CPAN module installation guide.