maximum database size of mysql database
Answers were Sorted based on User's Feedback
Answer / 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 |
How do you start MySQL on Linux?
What are the types of database engines available in mysql?
Explain % and _ inside like statement?
How do I free up space in mysql?
Restore database (or database table) from backup.
What is a session in mysql?
How do you change a password for an existing user via mysqladmin?
How do we delete a row in a table?
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
How to get full name of monthname ?
How do I install mysql?
What is csv?