title: MySQL defragment InnoDB tables
body: <p>After running mysqltuner, I received this output:</p>
  
  <pre><code>Total fragmented tables: 284
  </code></pre>
  
  <p>To defragment I tried these:</p>
  
  <pre><code>1. ALTER TABLE tbl_name ENGINE=INNODB
  2. Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file.
  </code></pre>
  
  <p>Both of the methods are described in <a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-file-defragmenting.html" rel="nofollow">MySQL documentation</a>.</p>
  
  <p>But none of the methods helped. Mysqltuner still says that tables are fragmented.</p>
  
  <p><strong>Note:</strong> <code>innodb_file_per_table</code> is OFF in my configurations.</p>
  
  <p>How can I defragment my InnoDB tables?</p>