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

How do I delete a table in mysql workbench?

0 Answers  

How would you enter characters as hex numbers?

0 Answers  

What is required to create mysql database?

0 Answers  

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

0 Answers  

How can I create table in mysql?

0 Answers  

maximum size of a database in mysql?

2 Answers  

How can you see all indexes defined for a table?

0 Answers  

What is the data source name for mysql?

0 Answers  

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

0 Answers  

How to execute mysql query in php?

0 Answers  

What is the maximum number of columns per table?

0 Answers  

What is the current root password of mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories