Question : get database size mysql
Answered by : tender-turkey-qruqj5ae0tmh
SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;
Source : https://stackoverflow.com/questions/1733507/how-to-get-size-of-mysql-database | Last Update : Mon, 25 Jan 21
Question : check database size in mysql
Answered by : rohit-ghodadra
// QUERY
SELECT table_schema AS "Database Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size in (MB)" FROM information_schema.TABLES GROUP BY table_schema;
Source : | Last Update : Wed, 21 Sep 22
Question : mysql db size
Answered by : leonardo-dal-ronco
SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;
Source : https://stackoverflow.com/questions/1733507/how-to-get-size-of-mysql-database | Last Update : Thu, 30 Apr 20
Question : get size of mysql database
Answered by : santosh-khanal
SELECT table_schema AS "Database",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.TABLES
GROUP BY table_schema;
Source : | Last Update : Fri, 12 Aug 22
Question : mysql size of database
Answered by : kennedy-carvalho
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / (1024 * 1024) "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Source : https://jonathanstreet.com/blog/disk-space-database-table-mysql-postgresql/ | Last Update : Tue, 30 Aug 22