# MySQL fragmentation(reorg)

**URL:** <https://forums.percona.com/t/mysql-fragmentation-reorg/4112>\
**Category:** Other MySQL® Questions\
**Created:** [March 20, 2015, 3:23am UTC](https://forums.percona.com/t/mysql-fragmentation-reorg/4112 "2015-03-20T03:23:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbarex](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dbarex](https://forums.percona.com/u/dbarex)\
**Post date:** [March 20, 2015, 3:23am UTC](https://forums.percona.com/t/mysql-fragmentation-reorg/4112/1 "2015-03-20T03:23:53Z")

</div>

Hello  
This is my first question. ^^

I have a question about the fragmentation (reorg) in mysql.

Q. If the statement(“delete/insert” ) is a frequent table, should be run periodically to “optimize table”?  
Because “randomI/O” is bad (not table size). Is it right?  
Q. Is there a way to query the table fragmentation like “innodb\_scan\_pages\_contiguous, Innodb\_scan\_pages\_jumpy”.

Thanks in advance for any help…

---

<div class="post-metadata">

**Author:** ![dbarex](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@dbarex](https://forums.percona.com/u/dbarex)\
**Post date:** [March 23, 2015, 2:44am UTC](https://forums.percona.com/t/mysql-fragmentation-reorg/4112/2 "2015-03-23T02:44:23Z")

</div>

I think that this is best solution.  
Matt is also the best.

- mariadb  
[url][Planet MySQL :: Planet MySQL - Archives - MariaDB 10.1.1: Defragmenting unused space on Inno...](http://planet.mysql.com/entry/?id=2058688%5B/url%5D)

- facebook  
[url][Percona Live MySQL Conference & Expo 2014](https://www.percona.com/live/mysql-conference-2014/sites/default/files/slides/defragmentation.pdf%5B/url%5D)