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 vote112 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote101 views2 answers
Mysql update two tables at once
SQL
3 votes118 views2 answers
Sqlite show table structure
SQL
0 vote109 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote95 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote100 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote99 views1 answer
Groupby sort sql hive
SQL
0 vote100 views3 answers
Convert sql query to python pandas
SQL
4 votes231 views2 answers
Sql display today's date
SQL
0 vote103 views1 answer
Top frequency in sql server
SQL