Skip to content

Instantly share code, notes, and snippets.

@quentindemetz
Created October 20, 2014 18:09
Show Gist options
  • Save quentindemetz/ea2ec1a09f71134d0b5f to your computer and use it in GitHub Desktop.
Save quentindemetz/ea2ec1a09f71134d0b5f to your computer and use it in GitHub Desktop.
mysql -u $user -p$password -h $host -NBe "SHOW TABLE STATUS;" $db | while read name engine version rowformat rows avgrowlength datalength maxdatalength indexlength datafree autoincrement createtime updatetime checktime collation checksum createoptions comment ; do
if [ "$datafree" -gt 0 ] ; then
fragmentation=$(($datafree * 100 / $datalength))
echo "$database.$name is $fragmentation% fragmented."
fi
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment