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

6 votes136 views3 answers
Sql select last id
SQL
0 vote166 views1 answer
Sparql if bound query
SQL
0 vote119 views1 answer
Search In the Database using Text
SQL
0 vote146 views1 answer
Mysql remove bad character from all fields
SQL
24 votes141 views6 answers
Alter table name sql
SQL
1 vote181 views1 answer
Oracle datafile max size 32gb
SQL
3 votes157 views1 answer
How to add unique constraint in mysql table
SQL
0 vote126 views1 answer
How to find symmetric pairs in sql
SQL
-1 vote171 views1 answer
Difference berween database and data base management system
SQL
2 votes138 views2 answers
Select sqlite3.OperationalError: no such column:
SQL