altmannmarcelo

# Many of these are obvious and stupidly simple, but for your reference and copy-pasting pleasure…


# Mextify all (with workaround for pesky samples that contain multi-line RSA key that breaks pt-mext)
for i in $(ls $1/*-mysqladmin); do { (cat $i | sed -e '/\-\-\-\-\-BEGIN\ PUBLIC\ KEY/,+9d' | pt-mext -r -- cat -) > $i.mext && echo $i.mext;} done;

# Inspect given variable through multiple mext samples (revealing ;-))
grep Table_locks_waited *.mext |less -S

#Find contentious tables