User Tools

Site Tools


mysql:get_all_databases_sizes

MySQL - Get All Databases Sizes

Get all Databases size from MySQL Server:

SELECT table_schema "Database Name", 
 Round(Sum(data_length + index_length) / 1024 / 1024, 1) "Size (MB)" 
FROM information_schema.tables 
GROUP BY table_schema;
mysql/get_all_databases_sizes.txt · Last modified: 2021/07/23 10:04 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki