Mysql get table size

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "bookstore"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

Source: chartio.com

Return size of tables in mysql

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Source: stackoverflow.com

Check size table

SELECT pg_size_pretty( pg_total_relation_size('tablename') );
(postgres)

-1

Similar codes

0 vote276 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote309 views1 answer
C# mysql data reader from two tables
SQL
0 vote394 views1 answer
Oracle db timestamp auto add
SQL
1 vote293 views1 answer
Show structure of table in sql
SQL
0 vote288 views1 answer
Using GROUP BY in MySQL Join Table
SQL
4 votes286 views3 answers
Create database in mySQL
SQL
-2 votes284 views1 answer
Mysql not empty
SQL
0 vote295 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote263 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote301 views1 answer
Create table as select sql server error
SQL