Niraj Chauhan

Niraj Chauhan

#father #husband #SoftwareCraftsman #foodie #gamer #OnePiece #naruto

MySQL get size of database

Posted by on

SELECT
table_schema 'Database Name',
sum(data_length + index_length) / 1024 / 1024 'Size(MB)'
FROM
information_schema.TABLES
GROUP BY table_schema;