Convert the output of pt-stalk to graphs
# Gotta have the latest version (2.1.2+)
$ wget percona.com/get/pt-stalk
# --run-time=1200 to get an hour of data.
# You can use any runtime, but graphs look
# really chunky with < 100 observations
$ ./pt-stalk --no-stalk --run-time=1200
bin/ <- Contains the master stalk2graph.rb and individual R files for each graph
$ brew install gfortran
$ brew install R
$ sudo gem install json
R> install.packages('ggplot2')
- Ordering is important for graph line addition. Update each R script to always explicitly graph the one with max() first. See innodb_buffer_pool.R for prior art.
- (via jay) I do still want the ability to upload individual files (like say a mysqladmin style file) and get the releated graphs without needing to pretend it's a whole pt-stalk output.
- Integrate Kenny's stuff
http://www.percona.com/doc/percona-monitoring-plugins/cacti/unix-templates.html
- Install and Configure R, Ruby, mod_ruby, and apache2
- Check out the repository into the target repository (usually http:///stalk2graph/
gem install passenger aptitude install curl-ssl openssl zlib-devel apt-get install libcurl libcurl-ssl-dev libcurl-dev apt-get install libcurl4 libcurlp-openssl-dev apt-get install libcurl3 libcurl3-openssl-dev apt-get install libapr1 libapr1-dev apt-get install apache2-prefork-dev libapr1-dev libaprutil1-dev