module Mycmd::SQL

Constants

ALL_DATABASE_SIZES
INNODB_BUFFER_HIT_RATE
QCACHE_HIT_RATE
QCACHE_SIZE

Public Class Methods

table_sizes(db) click to toggle source
# File lib/mycmd/sql.rb, line 11
def table_sizes(db)
  "SELECT T.TABLE_NAME, CAST(((T.DATA_LENGTH+T.INDEX_LENGTH)/1024/1024) AS CHAR) AS SIZE_MB FROM INFORMATION_SCHEMA.TABLES AS T WHERE T.TABLE_SCHEMA = '#{db}' UNION SELECT 'all_tables', CAST((SUM(T.DATA_LENGTH+T.INDEX_LENGTH)/1024/1024) AS CHAR) FROM INFORMATION_SCHEMA.TABLES AS T WHERE T.TABLE_SCHEMA = '#{db}'"
end