•  

Announcement

Announcement Module
Collapse
No announcement yet.

InnoDB and fragmentation

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB and fragmentation

    #1
    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
    Tags: None

  • #2
    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.

    Comment


    • #3
      Use xtrabackup with stats if you can't use Percona Server.

      Comment

      Working...
      X