Skip to content

Instantly share code, notes, and snippets.

@lukmdo

lukmdo/MYSQL DBA

Created February 24, 2010 12:03
Show Gist options
  • Save lukmdo/313363 to your computer and use it in GitHub Desktop.
Save lukmdo/313363 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL DBA
Raw
MYSQL DBA
DB table sizes overview
=======================
SELECT TABLE_NAME, TABLE_ROWS FROM information_schema.tables WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_ROWS DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment