1.mysql查看实例下，每个库的大小selectTABLE_SCHEMA,concat(truncate(sum(data_length)/1024/1024,2),'MB')asdata_size,concat(truncate(sum(index_length)/1024/1024,2),'MB')asindex_sizefrominformation_schema.tablesgroupbyTABLE_SCHEMAorderbydata_lengthdesc;2.mysql查看具体某个库里面的某个表的大小。selectconcat(round(sum(DATA_LENGTH/1024/1024),2),'M')fromtableswheretable_schema=\"${db}\"ANDtable_name=\"${table}\"3.查看mysql实例下，所有库下的每个表的大小。#!/bin/bash>allsize.txtfornin`catmysqlbackuplist.txt`doecho=========${n}=========>>allsize.txtfordbin`mysql-uroot-ppassword-h$n-e'showdatabases;'|awk'NR>1{print$1}'|egrep-v'schema|tmp|sys|innodb|mysql|tigasedb'`do>${db}size.txtecho=========${db}=========echo=========${db}=========>>allsize.txtfortablein`mysql-uroot-ppassword-h$n-e"use${db};showtables"`doselectsql="selectconcat(round(sum(DATA_LENGTH/1024/1024),2),'M')fromtableswheretable_schema=\"${db}\"ANDtable_name=\"${table}\";"mysql-uroot-ppassword-h$n-e"useinformation_schema;$selectsql"|awk-vtable=$table'NR>1{printtable""$1}'>>${db}size.txtdonecat${db}size.txt|sort-k2-rn>>allsize.txtdonedone