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 vote141 views4 answers
Mysql desactivar trigger
SQL
1 vote156 views1 answer
Sql how to replace full stop
SQL
0 vote160 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote2.8K views1 answer
PSQL use LIKE with timestamps
SQL
14 votes169 views3 answers
Inner join sql oracle
SQL
2 votes151 views1 answer
Mysql application.properties spring boot
SQL
18 votes144 views3 answers
Mysql number format
SQL
0 vote154 views1 answer
Setval in postgres
SQL
11 votes186 views2 answers
Having keyword sql
SQL
8 votes155 views2 answers
Oracle undo usage
SQL