Categories
Coding Technology

How to view the size of MySQL database(s) via the MySQL CLI

I thought I’d quickly post up this quick MySQL snippet to help others who are trying to quickly view the size of a MySQL database from the MySQL CLI. The following query displays the size of all your current MySQL databases on your server in megabytes:- SELECT table_schema “Data Base Name”, sum( data_length + index_length […]