Optimize Table

[kaits]

answer in german

OPTIMIZE TABLE - please, describe as simple as you can so that I understand it what is that, what does it, why good/bad ?

I saw into MySQL manual, but the description there is so difficult to understand

 

[brÅinstorm]

[color="dark-blue"]http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html[/color]

OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the datafile.

 

[kaits]

and what is that shortly? with one sentence?
the description in mysql manual is too difficult to understand
there should be a simple and short description for that

 

[brÅinstorm]

OPTMIZIE SAVES MEMORY BY REFORMATTING THE DATAFILE OF YOUR DATABASE

ok? =)

 

[kaits]

thanks

 

[brÅinstorm]

you're welcome. {*_;_*}