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

1 vote383 views3 answers
Postgresql get difference between two dates
SQL
0 vote344 views1 answer
SQL isnumeric DB2
SQL
2 votes367 views1 answer
SELECT INTO
SQL
0 vote340 views1 answer
Except in sql alchemy
SQL
0 vote380 views1 answer
Mysql 5.7 in centos 7
SQL
2 votes347 views3 answers
Postgres remove foreign key constraint
SQL
1 vote357 views1 answer
Count mysql server db tables
SQL
17 votes383 views6 answers
What is cursor in sql server with example
SQL
0 vote387 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote343 views1 answer
Rows, INSERT INTO, Returning with alias
SQL