Breaking News: Grepper is joining You.com. Read the official announcement!

mysql size of table

Add Answer

Kennedy Carvalho answered on December 19, 2020 Popularity 9/10 Helpfulness 7/10

answer mysql size of table

related mysql get table size

related return size of tables in mysql

mysql size of table

Comment

SELECT table_name, round(((data_length + index_length) / (1024*1024)),2) as "size in megs" FROM information_schema.tables WHERE table_schema = "named_db";

Popularity 9/10 Helpfulness 7/10 Language sql

Source: jonathanstreet.com

Tags: mysql size sql

Link to this answer
Share Copy Link

Contributed on Aug 23 2022

Kennedy Carvalho

0 Answers Avg Quality 2/10

Closely Related Answers

mysql get table size

Comments(1)

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;

Popularity 10/10 Helpfulness 10/10 Language sql

Source: chartio.com

Tags: get

Link to this answer
Share Copy Link

Contributed on Dec 19 2020

Calm Civet

0 Answers Avg Quality 2/10

return size of tables in mysql

Comment

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;

Popularity 10/10 Helpfulness 10/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 01 2021

Jittery Jackal

0 Answers Avg Quality 2/10

mysql size of table

Contents

More Related Answers

mysql size of table

Closely Related Answers

mysql get table size

return size of tables in mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.