前言
在開(kāi)發(fā)中我們想知道某個(gè)數(shù)據(jù)庫(kù)，或者某個(gè)數(shù)據(jù)表的內(nèi)存大小，那么怎么查詢呢？下面通過(guò)簡(jiǎn)單示例一一介紹，希望對(duì)您有所幫助。文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-569279.html
?某表每行所占字節(jié)數(shù)
SELECT
TABLE_NAME ,
CONCAT((DATA_LENGTH + INDEX_LENGTH), ' 字節(jié)') AS '每行占用字節(jié)數(shù)'
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = '你的數(shù)據(jù)庫(kù)名'
AND
TABLE_TYPE = 'BASE TABLE';
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-569279.html
?某個(gè)數(shù)據(jù)庫(kù)各表所占內(nèi)存大小
SELECT
table_schema AS "數(shù)據(jù)庫(kù)",
table_name AS "表名",
table_rows AS "記錄數(shù)",
TRUNCATE ( data_length / 1024 / 1024, 2 ) / 1024 AS "數(shù)據(jù)容量（GB）",
TRUNCATE ( index_length / 1024 / 1024, 2 ) / 1024 AS "索引容量（GB）"
FROM
information_schema.TABLES
WHERE
table_schema = '你的數(shù)據(jù)庫(kù)名稱'
ORDER BY
data_length DESC,
index_length DESC;到了這里，關(guān)于MySQL查詢數(shù)據(jù)庫(kù)、表以及表行數(shù)所占內(nèi)存大小的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
