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 purpose of using ifnull() function?

0 Answers  

how many fields can be updated using set in a mysql query?

1 Answers  

How to delete a column and add a new column to database

0 Answers  

Can I use mariadb instead of mysql?

0 Answers  

What is the difference between database and table?

0 Answers  




Are stored procedures precompiled?

0 Answers  

How to install mysql?

0 Answers  

How does triggers work in mysql?

0 Answers  

What is different between sql and mysql?

0 Answers  

How much does mysql cost?

0 Answers  

Which storage engines support transactions in MySQL?

2 Answers  

How to copy data from one server to another using php?

0 Answers  

For more MySQL Interview Questions Click Here
Categories