search

Home >Database >Mysql Tutorial >MySQL 获取数据库实际的大小

MySQL 获取数据库实际的大小

WBOY
WBOYOriginal
2016-06-07 14:55:021109browse

通过一个SQL语句便可知道你的数据库占用多大的空间 无 SELECTCONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%YOUR_DATABASE_NAME_HERE%' ;-- 其

通过一个SQL语句便可知道你的数据库占用多大的空间 
SELECT
CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size 
FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%YOUR_DATABASE_NAME_HERE%' ;

-- 其中YOUR_DATABASE_NAME_HERE便是你的数据库名
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：NOT IN使用注意事项Next article：mydns tables structure

Related articles

See more