Skip to content

Rich Collier

Father & Husband, Adventurer, FPVer, Code Wrangler @ Automattic

  • FPV
    • My Drones
    • Videos
  • Photography
  • WordPress
  • @rich_fpv
    • YouTube
    • Instagram
    • Twitter

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]

Rich Collier Linux, MySQL, Web Development Leave a comment December 16, 2016 1 Minute
  • Contact
  • Get Plasmatree PID Analyzer up and running on MBP/OSX
  • My Drones
  • Sad Starfish
  • Puffy LiPos

Categories

  • Adventures
  • AutoGalleries
  • Automattic
  • Aviation
  • AWS
  • Betaflight
  • Brewing
  • Family
  • Fishing
  • Florida Life
  • Food
  • FPV
  • Geek Stuff
  • Going Vegan-ish
  • Home Assistant
  • Javascript
  • Linux
  • Music
  • MySQL
  • Not On Homepage
  • Parenthood
  • Photography
  • Projects
  • Recipes
  • Scuba
  • Snorkeling
  • Systems Configs
  • Travel
  • Tutorials
  • Uncategorized
  • Video
  • Web Development
  • WordPress
  • WordPress Code
Powered by WordPress.com.