maximum database size of mysql database

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many rows can mysql handle?

501


What port is mysql running on?

476


How to calculate the difference between two time values?

453


What is the size of mysql database?

487


How to use regular expression in pattern match conditions?

515






What is not null in mysql?

511


How to make a column bigger and delete unique from table.

476


How do I find mysql database?

480


What are date and time data types?

494


Why do we use the mysql database server?

530


What is pragma exception?

537


Where is the mysql data directory?

495


What is a tinyint?

509


What is int mysql?

513


How to load a csv file into a table

545