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 vote274 views1 answer
Compare subqueries oracle
SQL
4 votes248 views1 answer
Wilayah indonesia sql
SQL
0 vote269 views1 answer
Multiple replace value mssql
SQL
3 votes272 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote263 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
39 votes306 views4 answers
Select duplicates in sql
SQL
5 votes272 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote243 views1 answer
Postgres select except
SQL
3 votes244 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote200 views1 answer
Ms sql - add one hour to time
SQL