class Stackeye::Metrics::Mysql

Public Instance Methods

generate_data() click to toggle source
# File lib/stackeye/metrics/mysql.rb, line 13
def generate_data
  generate_stats
end

Private Instance Methods

generate_stats() click to toggle source
# File lib/stackeye/metrics/mysql.rb, line 19
def generate_stats
  cmd = "mysqladmin -u#{user} -h#{host} -p#{password} status"
  lines = Stackeye::Tools::Cli.execute(cmd).split("\n")
  stats = lines.last.strip.split('  ')

  stats.each do |stat|
    key, val = stat.split(': ')
    key = key.downcase.tr(' ', '_')
    key = 'velocity' if key == 'queries_per_second_avg'

    @data[key] = val.to_f.round(2)
  end
end