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

get size of mysql database particular table

Add Answer

santosh khanal answered on August 5, 2022 Popularity 6/10 Helpfulness 6/10

answer get size of mysql database particular table

related get size of mysql database

related mysql size of database

get size of mysql database particular table

Comment

SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "database_name"
ORDER BY (data_length + index_length) DESC;
// replace database_name with your database

Popularity 6/10 Helpfulness 6/10 Language sql

Source: www.a2hosting.com

Tags: database get mysql size sql

Link to this answer
Share Copy Link

Contributed on Apr 05 2023

santosh khanal

0 Answers Avg Quality 2/10

Closely Related Answers

get size of mysql database

Comment

SELECT table_schema AS "Database", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" 
FROM information_schema.TABLES 
GROUP BY table_schema;

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Aug 05 2022

santosh khanal

0 Answers Avg Quality 2/10

mysql size of database

Comment

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / (1024 * 1024) "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: jonathanstreet.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Aug 23 2022

Kennedy Carvalho

0 Answers Avg Quality 2/10

get size of mysql database particular table

Contents

More Related Answers

get size of mysql database particular table

Closely Related Answers

get size of mysql database

mysql size of database

Grepper

Documentation

Social

Legal

Contact

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