濡傛灉鎯崇煡閬?/p>
MySQL
鏁版嵁搴撲腑姣忎釜琛ㄥ崰鐢ㄧ殑绌洪棿銆?/p>
琛ㄨ褰曠殑琛屾暟鐨勮瘽锛?/p>
鍙互鎵撳紑
MySQL
鐨?/p>
information_schema
鏁版嵁搴撱�傚湪璇ュ簱涓湁涓�涓?/p>
TABLES
琛紝杩欎釜琛ㄤ富瑕佸瓧娈靛垎鍒槸锛?/p>
TABLE_SCHEMA :
鏁版嵁搴撳悕
TABLE_NAME
锛氳〃鍚?/p>
ENGINE
锛氭墍浣跨敤鐨勫瓨鍌ㄥ紩鎿?/p>
TABLES_ROWS
锛氳褰曟暟
DA
TA_LENGTH
锛氭暟鎹ぇ灏?/p>
INDEX_LENGTH
锛氱储寮曞ぇ灏?/p>
鍏朵粬瀛楁璇峰弬鑰?/p>
MySQL
鐨勬墜鍐岋紝杩欏嚑涓瓧娈靛鎴戜滑鏉ヨ鏈�鏈夌敤銆?/p>
涓�涓〃鍗犵敤绌洪棿鐨勫ぇ灏忥紝鐩稿綋浜庢槸
鏁版嵁澶у皬
+
绱㈠紩澶у皬
,
绀轰緥锛?/p>
1.
鎯虫煡鐪?/p>
hx
搴撶殑鎵�鏈夎〃澶у皬锛屽彲浠ヤ娇鐢細
浠ｇ爜濡備笅
:
SELECT
TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS
FROM
information_schema.TABLES WHERE TABLE_SCHEMA='hx';
+-------------------+--------------------------+------------+
| TABLE_NAME | DATA_LENGTH+INDEX_LENGTH | TABLE_ROWS |
+-------------------+--------------------------+------------+
| enjoy_data | 6979584 | 70113 |
| hx_record | 113410048 | 753279 |
| itlearner_record | 21835546624 | 104917777 |
| tmp_day_id | 17326 | 811 |
+-------------------+--------------------------+------------+
2.
鎯虫煡鐪?/p>
hx
搴撶殑
enjoy
琛ㄥぇ灏忥紝鍙互浣跨敤锛?/p>
浠ｇ爜濡備笅
:
SELECT
DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA='hx'
AND
TABLE_NAME
=
'enjoy_data';
杩斿洖锛?/p>
浠ｇ爜濡備笅
:
+--------------------------+------------+
| DATA_LENGTH+INDEX_LENGTH | TABLE_ROWS |
+--------------------------+------------+
| 6979584 | 70113 |
+--------------------------+------------+
鏇村淇℃伅璇锋煡鐪?/p>
IT
鎶�鏈笓鏍?/p>