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 vote96 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote110 views1 answer
Psql generate id in existing database
SQL
4 votes95 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote98 views1 answer
Firebase sql
SQL
1 vote57 views1 answer
Database run
SQL
0 vote110 views1 answer
Sql ignore
SQL
5 votes117 views6 answers
In operator sql
SQL
0 vote107 views1 answer
Excel export from sql using python
SQL
0 vote96 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
49 votes174 views6 answers
Get duplicate records in sql
SQL