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

What is mysql installer?

0 Answers  


how to add a new column to an existing table?

0 Answers   MCN Solutions,


How to include character strings in sql statements?

0 Answers  


What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers   SigmaTree,


What are the functions of commit and rollback statements?

0 Answers  






Are stored procedures precompiled?

0 Answers  


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

0 Answers  


How can I create database in mysql?

0 Answers  


What ascii 31?

0 Answers  


What are aggregate functions in mysql?

1 Answers  


How do I find my mysql username and password?

0 Answers  


What is the use of mysqli_query?

0 Answers  


Categories