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 vote191 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote202 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote206 views2 answers
Mysql extract number from string
SQL
2 votes175 views1 answer
Pandas to sql index
SQL
1 vote242 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote245 views2 answers
Begin transaction sql
SQL
0 vote175 views1 answer
Oracle grant create job
SQL
3 votes187 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
6 votes180 views2 answers
Where clause in sql
SQL
0 vote196 views1 answer
How to make case insensitive in sql
SQL