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 |
What is mysql uuid?
What is relational database in mysql?
What is latest version of mysql?
Is oracle mysql free?
What are the column comparisons operators?
what is the Dynamic management views? where can you use?
Can we use mysql and mysqli together?
How to use like conditions?
Explain the difference between mysql and mysqli interfaces in PHP?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What do you mean by % and _ in the LIKE statement?
What are the limitations of mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)