大表统计SQL

SELECT
'机器IP',
'端口',
col.table_schema,
col.TABLE_NAME,
round(
(
ts.data_length + ts.index_length + ts.data_free
) / 1024 / 1024 / 1024,
2
) AS 'G',
col.COLUMN_NAME,
col.DATA_TYPE,
ts.AUTO_INCREMENT
FROM
information_schema. TABLES AS ts,
information_schema.KEY_COLUMN_USAGE AS k,
information_schema. COLUMNS AS col
WHERE
ts.TABLE_NAME = k.TABLE_NAME
AND ts.TABLE_NAME = col.TABLE_NAME
AND k.COLUMN_NAME = col.COLUMN_NAME
AND k.CONSTRAINT_NAME = 'PRIMARY'
AND (
ts.DATA_LENGTH + ts.INDEX_LENGTH + ts.DATA_FREE
) > 10 * 1024 * 1024 * 1024;