admin 发表于 2019-3-25 17:45:41

统计mysql总行数和总数据量

mysql> use information_schema;

mysql> select sum(TABLE_ROWS),concat(round(sum(data_length/1024/1024/1024),2),'GB') as data from tables;

页: [1]
查看完整版本: 统计mysql总行数和总数据量