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 vote190 views1 answer
Mysqli connect
SQL
1 vote215 views1 answer
Mysql show attributes of a table
SQL
1 vote216 views1 answer
Age postgres
SQL
1 vote212 views2 answers
T sql get foreign key
SQL
0 vote206 views1 answer
Mysql url data type
SQL
1 vote205 views1 answer
Join to find results not in another table
SQL
1 vote222 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote209 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote225 views1 answer
Mysql insert into select transaction c#
SQL
3 votes195 views2 answers
Having in mysql
SQL