统计

统计文件数量

sudo find /data/ -type f -print | wc -l

统计文件大小

du -sh /data/*

mysql统计行数

SELECT sum(TABLE_ROWS),sum((DATA_LENGTH+INDEX_LENGTH)/1024/1024) FROM information_schema.TABLES WHERE TABLE_SCHEMA='tables';

mysql统计大小

SELECT TABLE_NAME,TABLE_ROWS,(DATA_LENGTH+INDEX_LENGTH)/1024/1024 AS TOTAL_MB FROM information_schema.TABLES WHERE TABLE_SCHEMA='tables' ORDER BY TABLE_ROWS DESC limit 100;