mysqlGet total size of specific databse
SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) FROM information_schema.tables WHERE table_schema = 'db';ctrl + cROUND(SUM(data_length + index_length) / 1024 / 1024, 1)will return final size in Megabytes | information_schema.tablessystem table with meta data for all tables on server |
table_schema = 'db'we get total size for | |
Related
More of Mysql
- Insert/update multiple rows in single query
- How to find my.cnf config file
- Disable ONLY_FULL_GROUP_BY mode
- Get largest tables list
- Truncate all tables in a specific database
- How to find duplicate varchar/text column values in table
- What is the MEDIUMTEXT column max size (length) in Mysql
- What is the TINYINT column max value and size in Mysql
- What is the LONGTEXT column max size (length) in Mysql
- Skip certain tables while doing dump
See more codes...