class Mycmd::StatusCommands

Public Instance Methods

innodb_buffer_hit_rate() click to toggle source
# File lib/mycmd/cli/status_commands.rb, line 29
def innodb_buffer_hit_rate
  begin
    print_rate(Client.query(SQL::INNODB_BUFFER_HIT_RATE).result, 90)
  rescue => e
    puts e.message
  end
end
qcache_hit_rate() click to toggle source
# File lib/mycmd/cli/status_commands.rb, line 19
def qcache_hit_rate
  begin
    raise "Query cache is disabled." if Client.query(SQL::QCACHE_SIZE).result.first["size"] == "0"
    print_rate(Client.query(SQL::QCACHE_HIT_RATE).result, 20)
  rescue => e
    puts e.message
  end
end
size() click to toggle source
# File lib/mycmd/cli/status_commands.rb, line 9
def size
  begin
    sql = options["database"].nil? ? SQL::ALL_DATABASE_SIZES : SQL.table_sizes(options['database'])      
    Client.query(sql).print
  rescue => e
    puts e.message
  end
end

Private Instance Methods

print_rate(rate, threshold) click to toggle source