PATH:
usr
/
local
/
sbin
#!/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
[-] 1
[edit]
[-] 99
[edit]
[-] 11
[edit]
[-] 25bl
[edit]
[+]
..
[-] 2
[edit]
[-] portchk
[edit]
[-] restrict
[edit]
[-] 80
[edit]
[-] 12
[edit]
[-] 33
[edit]
[-] 5
[edit]
[-] 7
[edit]
[-] mqkill
[edit]
[-] 3
[edit]
[-] 88
[edit]
[-] dai
[edit]
[-] logs
[edit]
[-] 4
[edit]
[-] ukill
[edit]
[-] c
[edit]
[-] 25
[edit]
[-] 22
[edit]
[-] 6
[edit]
[-] bl
[edit]