InnoDB Disk fragmentation

InnoDB Disk fragmentation

Here is how you can check the innodb fragmentation.

mysql> SELECT SUM(DATA_LENGTH+INDEX_LENGTH) FROM TABLES WHERE ENGINE='INNODB';
+-------------------------------+
| SUM(DATA_LENGTH+INDEX_LENGTH) |
+-------------------------------+
| 455770112 |
+-------------------------------+
1 row in set (4 min 43.31 sec)

mysql> system ls /var/lib/mysql/ibdata* -l
-rw-rw---- 1 mysql mysql 1251999744 Apr 22 09:32 /var/lib/mysql/ibdata1