1. mysql 查看实例下,每个库的大小
select TABLE_SCHEMA, concat(截断(总和(data_length)/1024/1024, 2),, MB), as data_size,
concat(截断(总和(index_length)/1024/1024, 2),“m”), as index_size
得到information_schema.tables
group by TABLE_SCHEMA
order by data_length desc;
2. mysql 查看具体某个库里面的某个表的大小。
select concat(圆(sum (DATA_LENGTH/1024/1024), 2),“M”),得到tables where table_schema=\ " $ {db} \ ",以及table_name=\ " ${表}\ "
3 .查看mysql 实例下,所有库下的每个表的大小。
# !/bin/bash
祝辞allsize.txt
for n cat mysqlbackuplist.txt的拷贝
做
,,,,,,,echo =========, $ {n},=========,,在祝辞allsize.txt
,,,for db 拷贝的mysql -uroot -ppassword - h n 美元;-e “show 数据库;”,| awk ,“NR> 1} {print 1美元的| egrep -v “模式| tmp | sys | innodb mysql | | tigasedb ' '
,才能做
,,,,,,,的在$ {db} size.txt
,,,,,,,echo =========, $ {db},=========,,,,,,,echo =========, $ {db},=========,祝辞祝辞allsize.txt
,,,,,,,for table 拷贝的mysql -uroot -ppassword - h n 美元;-e “use $ {db}, show 表”的
,,,,,,,
,,,,,,,,,,,selectsql=皊elect concat(圆(sum (DATA_LENGTH/1024/1024), 2),“M”),得到tables where table_schema=\ " $ {db} \“table_name害=\ " ${表}\”;“
,,,,,,,,,,,mysql -uroot -ppassword - h n 美元;-e “use information_schema, selectsql美元”,| awk -v 表=$ table ' NR> 1 {print table ",, ", $ 1}’,,在祝辞{db} size.txt美元
,,,,,,,,,,,
,,,,,,,
,,,,,,,cat $ {db} size.txt | sort -k 2, -rn 在祝辞allsize.txt
,,,done
以前做
