Skip to content

Rich Collier

global explorer, tech team lead, aviator, father, husband

  • Travel
  • Tech
  • Family
  • About me

Category: MySQL

Get disk usage information for MySQL databases

Ever wonder how much space your MySQL database uses? Here you go:

[sql]SELECT table_schema "Database",
SUM( data_length + index_length ) / 1024 / 1024 "MB used",
SUM( data_free ) / 1024 / 1024 "MB free"
FROM information_schema.TABLES
GROUP BY table_schema;[/sql]

Author Rich CollierPosted on December 16, 2016Format AsideCategories Linux, MySQL, Web DevelopmentLeave a comment on Get disk usage information for MySQL databases
  • Travel
  • Tech
  • Family
  • About me
Theme: Twenty Sixteen. Rich Collier Powered by WordPress.com.