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 check if value already exists in mysql database in php?

824


What is limit in mysql?

824


What are Heap tables?

1476


Can you tell what are various ways to create an index?

817


How can you see all indexes defined for a table?

1061


What is mysql data directory?

922


How do I copy a table in mysql?

882


How to return query output in xml format?

981


What are the different data types in mysql?

877


How can you increase the performance of mysql select query?

872


What is default password for mysql?

827


Is mariadb better than mysql?

985


Does mysql support sequence?

882


How many columns is too many mysql?

842


How do I disconnect mysql workbench?

995