linux 查找大文件 :
find / -type f -size <文件大小> -print0 | xargs -0 du -h
mysql 查看表占用大小:
SELECT
CONCAT( table_schema, '.', table_name ) AS 'Table Name',
CONCAT( ROUND( table_rows / 1000000, 4 ), 'M' ) AS 'Number of Rows',
CONCAT( ROUND( data_length / ( 1024 * 1024 * 1024 ), 4 ), 'G' ) AS 'Data Size',
CONCAT( ROUND( index_length / ( 1024 * 1024 * 1024 ), 4 ), 'G' ) AS 'Index Size',
CONCAT( ROUND( ( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 4 ), 'G' ) AS 'Total'
FROM
information_schema.TABLES
WHERE
table_schema LIKE <表名>