Hello Antonio, As Reindl said, it is recommended but it shouldnt be done just everyday if your tables are quite big and you use query cache.
If you do have lot of writes and deletes (depending on what you consider a lot), your table will indeed have lot of 'blank rows' which eat disk space. Optimizing tables if good for both: saving disk space and reading faster from them. However, remember that optimize locks your table so it can affect your writes and create a big overhead in your server (IO). If I were your I would benchmark how fast my operations are after a...lets say monthly optimize and then decide. I am assuming you are not optimizing because of disk space issues. Manuel 2013/3/28, Antonio Fernández Pérez <antoniofernan...@fabergames.com>: > Ok. Thank you very much. > > Best regards, > > Antonio. > -- Manuel Aróstegui Systems Team tuenti.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
