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 a storage engine? What are the differences between innodb and myisam engines?

0 Answers  


Is mysql a server?

0 Answers  


what is the difrence between sql and pl/sql

21 Answers   Wipro,


How To see all the tables from a database of mysql server.

0 Answers  


date funciton

2 Answers  


Is mysql open source?

0 Answers  


What happens if a table has one column defined as TIMESTAMP?

1 Answers  


Which statement is used in a select query for partial matching?

0 Answers  


What are the advantages/disadvantages of mysql and php?

0 Answers  


what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

10 Answers   E2 Solutions, Tesco,


Write a program using the select statement, while loop.

0 Answers  


What is the data source name for mysql?

0 Answers  


Categories