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

-2 votes303 views2 answers
Sqlserver docker
SQL
2 votes311 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote358 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
7 votes327 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote341 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote324 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
1 vote322 views1 answer
Tsql get beginning of year
SQL
1 vote335 views1 answer
Postgres set column based on another column
SQL
6 votes389 views2 answers
Oracle compile trigger
SQL
2 votes327 views2 answers
Mysql find max value row
SQL