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 size of a database in mysql?

Answer Posted / a.kishan kumar

mysql> select
table_schema,sum(data_length+index_length)/1024/1024 from
information_schema.tables group by table_schema;

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run a query in mysql?

927


How to write date and time literals?

1003


How do I start mysql in linux?

882


How do I edit a table in mysql?

872


How can you filter the duplicate data while retrieving records from the table?

878


How to create a new table in mysql?

1018


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

898


How many columns can a table have?

894


why not null is not allowed at table level

2736


What is mvcc in mysql?

974


What is the difference between the LIKE and REGEXP operators?

1014


Is mysql a programming language?

872


Where is the mysql config file?

967


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2812


How can you see all indexes defined for a table?

1098