maximum database size of mysql database

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 you start MySQL on Linux?

3 Answers  


What are the types of database engines available in mysql?

0 Answers  


Explain % and _ inside like statement?

0 Answers  


How do I free up space in mysql?

0 Answers  


Restore database (or database table) from backup.

0 Answers  






What is a session in mysql?

0 Answers  


How do you change a password for an existing user via mysqladmin?

2 Answers  


How do we delete a row in a table?

0 Answers  


how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 Answers  


How to get full name of monthname ?

4 Answers  


How do I install mysql?

0 Answers  


What is csv?

0 Answers  


Categories