quentindemetz · October 20, 2014 18:09
diff --git a/MySQL fragmentation b/MySQL fragmentation
 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
	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