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