Hi,
I am lost trying to find out whether or not there is a way to measure fragmentation on InnoDB tables. The idea is not to rebuild tables where it is not needed.
Do you know the magic formula ?
Thank you
Hi,
I am lost trying to find out whether or not there is a way to measure fragmentation on InnoDB tables. The idea is not to rebuild tables where it is not needed.
Do you know the magic formula ?
Thank you
What version of MySQL are you running?
Since you need something like the Percona innodb_check_fragmentation patch if you are going to be able to see it.
Use xtrabackup with stats if you can’t use Percona Server.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.