Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 to use sum function in where clause in mysql?

964


In which language mysql has been written?

1336


Is mongodb faster than mysql?

953


How do stored procedures work?

1050


How do I run mysql?

1012


How to enter microseconds in sql statements?

986


Is number a datatype in mysql?

948


How can you move the master database

2046


How do I view tables in mysql workbench?

920


What are the different types of triggers in mysql?

963


How to create a new table in mysql?

1047


How is mysql database stored?

1072


How to create trigger in mysql phpmyadmin?

1104


can you elaborate on blob and text in mysql? : Mysql dba

897


Why we use mysqli instead of mysql?

1090