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
Where MyISAM table will be stored and also give their formats of storage?
Is mysql owned by oracle?
What is pragma autonomous_transaction?
What is the phantom problem?
How do I edit a table in mysql?
What is difference between mongodb and mysql?
How do I disable mysql?
What is the use of mysql workbench?
Is sql similar to mysql?
How to set the time zone for MySQL to particular country time?
How do I remove a user from mysql?
How do I start mysql database?
What is delimiter $$?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
How do I find users in mysql?
