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
# File lib/mycmd/cli/status_commands.rb, line 38 def print_rate(rate, threshold) if rate.nil? rate = "\e[31munknown\e[m" else rate = rate.first["rate"].to_i rate = rate >= threshold ? "\e[32m#{rate} %\e[m" : "\e[31m#{rate} %\e[m" end puts rate end