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 vote145 views1 answer
Rename constraint postgresql
SQL
8 votes182 views1 answer
Insert a select statement into a table
SQL
0 vote186 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
1 vote139 views1 answer
Mysql drop key
SQL
0 vote131 views1 answer
What is logical database schema
SQL
7 votes154 views2 answers
Where keyword sql
SQL
0 vote130 views1 answer
Deny select insert update delete sql
SQL
0 vote147 views1 answer
Geopoint from json mysql function
SQL
0 vote141 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote90 views1 answer
Insert into sql
SQL