mysql数据总存量(GB)
SELECT
CONCAT( ROUND( SUM( DATA_LENGTH + INDEX_LENGTH ) / 1024 / 1024 / 1024, 2 ), ' GB' ) AS total_size
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'your_database_name';
数据总行数(条数)
SELECT
sum( table_rows )
FROM
TABLES
WHERE
TABLE_SCHEMA = 'your_database_name';