Defragmenting InnoDB

G

Georg2012-10-27 16:08:05

MySQL

Georg, 2012-10-27 16:08:05

Good afternoon. How to defragment tables in InnoDB?
In all tables phpmyadmin writes
Фрагментировано 2,346.0 МБ
Optimization does not help. The volume of the database is 3 GB.

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

A

AGvin, 2012-10-27
@AGvin

If the process you called "defragmentation" used "OPTIMIZE TABLE", then nothing will happen to the size of the table. As I have seen, everywhere they recommend dumping the table, deleting it and uploading the dumped version.

D

Dmitry Goryachev, 2012-10-27
@Gordim

dev.mysql.com/doc/refman/5.6/en/optimize-table.html

D

Diam0n, 2012-10-27
@Diam0n

mysqlcheck -Ao -p will
recreate the tables - defragmentation will decrease accordingly