linux查看数据库空间大小

mysql -u username -p -e "SELECT table_schema AS 'Database', SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)' FROM information_schema.TABLES GROUP BY table_schema;"

mysql -u username -p -e "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) as 'Size (MB)' FROM information_schema.TABLES WHERE table_schema = 'your_database_name' ORDER BY (data_length + index_length) DESC;"

psql -U username -d your_database_name -c "SELECT pg_size_pretty(pg_database_size(current_database()));"

psql -U username -d your_database_name -c "SELECT schemaname, tablename, pg_size_pretty(pg_total_relation_size(schemaname || '.' || tablename)) FROM pg_tables WHERE schemaname = 'public' ORDER BY pg_total_relation_size(schemaname || '.' || tablename) DESC;"

mongo --eval "db.stats(1024*1024)"

mongo --eval "db.getCollection('your_collection_name').stats(1024*1024)"

ls -lh your_database_file.db