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

3 votes284 views3 answers
Mysql auto increment after delete
SQL
0 vote254 views1 answer
Mysqlimport
SQL
0 vote290 views1 answer
Change role postgres
SQL
0 vote273 views1 answer
How to check which table has data in mysql
SQL
0 vote281 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote279 views1 answer
Sqlalchemy one column of two has to be not null
SQL
11 votes253 views2 answers
Sql rank
SQL
5 votes240 views1 answer
Mysql select greater than yesterday
SQL
1 vote280 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote268 views1 answer
Create date sql
SQL