Does MYSQL do "OPTIMAZE TABLE" online ???

  • Filter
  • Time
  • Show
Clear All
new posts

  • Does MYSQL do "OPTIMAZE TABLE" online ???

    Hi all,
    Probably it is dump question, but I couldn't find it in the documentation and this forum.

    Q1: When I do "OPTIMIZE TABLE" (table has MyISAM type), does MySQL lock this table?

    Q2: Is this operation online?

    Q3: Is that right that, in during the "OPTIMIZE TABLE" process, MySQL is copying everything into a temp table and then copies it back when this operation will be finished. Am I right?

    What I need to do is to create a trigger to purge a data older then 6 month from an original table to archive table and then optimize them both.

    Q4: Are there any better methods to purge the old data to the different tables?

    Thanks in advance. Any answers are appreciated.