Script to list all MySQL databases and disk usage in Plesk
if [ -d /var/lib/mysql ]; then echo -ne "\n\n=== MySQL DATABASES ===\n"; mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "SELECT round(sum( data_length + index_length )/1024/1024,0) 'SM', table_schema 'DN' FROM information_schema.TABLES GROUP BY table_schema ORDER BY SM DESC \G;" | sed '/\*\*\*/d' | sed 's/SM: //' | sed ':a;N;$!ba;s/\nDN:/M\t/g'; fi;
============
Regards,
Vinod T K
