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
Is mysql port 3306 tcp or udp?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
Write a query to count the number of rows of a table in mysql.
What are procedures in mysql? Explain
What is int unsigned?
How to see the create table statement of an existing table?
What is the data source name for mysql?
How to use case expression?
Explain timestamp?
How does mysql store binary data?
What is mysql cursor?
Give string types available for column?
what is constraints?
What is a tinyint in mysql?
How to control the max size of a heap table?