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
How to check if value already exists in mysql database in php?
What is limit in mysql?
What are Heap tables?
Can you tell what are various ways to create an index?
How can you see all indexes defined for a table?
What is mysql data directory?
How do I copy a table in mysql?
How to return query output in xml format?
What are the different data types in mysql?
How can you increase the performance of mysql select query?
What is default password for mysql?
Is mariadb better than mysql?
Does mysql support sequence?
How many columns is too many mysql?
How do I disconnect mysql workbench?