a couple of handy perl snippets & scripts

QueryGrab.pl allows you to grab queries directly out of mysql while it is running. This can be very handy if you can not use the general querylog.

Also to Show the largest tables in the db…

mysql -B -e “show table status from <databasename>”| awk ‘{print $5, $1}’ | sort -n

This entry was posted in linux, mysql, performance, Perl. Bookmark the permalink.