0
0 answers 1,322 views 6 years ago

How to get the size of a database in MySQL?

MySQL Query for getting size of database in a schema




SELECT table_schema `your_database_name`, ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"

FROM information_schema.tables

GROUP BY table_schema;


Share:
S
Student User
Asked 6 years ago

0 Answer(s)

No answers yet

Be the first to help by answering this question!

Login to Answer

Login Required

Please login to submit an answer.

Community pulse
  • Total questions216
  • Answers posted19
  • Accepted answers0
  • Active learners11
Related questions

Need personalised help?

Start a new discussion and get answers from verified teachers & toppers.

Ask now