#!/bin/bash #Get MySQL process list mysqladmin processlist > /tmp/mysql-q #Get Db size for i in `cat /tmp/mysql-q | awk {'print $8'} | grep -v "mysql" | grep -v "db" | grep -v "|"`; do cat /root/dbsizes_backup | grep $i >> /tmp/mysql-q-sort; done #Sort by size echo "#####NQ#Size####DB Name###########################" sort -n /tmp/mysql-q-sort | uniq -c echo "#####NQ#Size####DB Name###########################" rm -rf /tmp/mysql-q rm -rf /tmp/mysql-q-sort
cải xoăn