Skip to content

Instantly share code, notes, and snippets.

@deevis

deevis/gist:7d675e1824ed845e1d2e

Created January 9, 2015 17:38
Show Gist options
  • Save deevis/7d675e1824ed845e1d2e to your computer and use it in GitHub Desktop.
Save deevis/7d675e1824ed845e1d2e to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Storage summary into Ruby Hash
Raw
gistfile1.rb
db_name = Rails.configuration.database_configuration[Rails.env]["database"]
sql = "SELECT table_name AS name, table_rows, data_length, index_length FROM information_schema.TABLES WHERE table_schema = '#{db_name}' ORDER BY (data_length + index_length) DESC;"
table_data = ActiveRecord::Base.connection.execute(sql).map{|r| {name: r[0], rows: r[1], data_size: r[2], index_size: r[3]}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment