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 vote187 views1 answer
Mysql coonect sample code
SQL
14 votes176 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
17 votes189 views4 answers
Postgres list users
SQL
6 votes217 views4 answers
Mysql get random row
SQL
0 vote188 views1 answer
Sql count * vs count 1
SQL
0 vote216 views1 answer
Sql today at midnight
SQL
8 votes209 views1 answer
Mysql restore database
SQL
23 votes176 views6 answers
How to create table in sql
SQL
5 votes193 views1 answer
Sql use database
SQL
0 vote173 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL