Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

maximum database size of mysql database

Question Posted / sandeep kumar

Answers were Sorted based on User's Feedback



maximum database size of mysql database..

Answer / pandu

Run the below query you can get the Data Base Size in MySQL.

If you run the query which is given below in MySQL Query
Browser then you will get the two columns first will display
the Data Base Name and the second will display the Data Base
Size in MB.

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 ;

Is This Answer Correct ?    0 Yes 0 No

maximum database size of mysql database..

Answer / ramkumar

1 bytes

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More MySQL Interview Questions

What is the return type of mysqli_query?

0 Answers  

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 Answers  

How do I exit mysql?

0 Answers  

What is blob in mysql?

0 Answers  

How do you stop an access query?

0 Answers  

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  

What is difference b/w composit key n primary key and forigion key?

4 Answers  

What is a left join mysql?

0 Answers  

How do you flush privileges?

0 Answers  

How do I create a database in mysql workbench?

0 Answers  

How can you move the master database

0 Answers   IBM,

What is save point in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories