Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Local Option For Optimize

forums › forums › SQLyog › Using SQLyog › Local Option For Optimize

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 30, 2010 at 4:29 pm #31760
      peterlaursen
      Participant

      Refer MySQL documentation: http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

      Quote:
      By default, OPTIMIZE TABLE statements are written to the binary log so that they will be replicated to replication slaves. Logging can be suppressed with the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL.

      Maybe we should replace LOCAL with NO_WRITE_TO_BINLOG keyword. LOCAL is probably an 'old form' now. But if you do not have binlog enabled and don't use replication it does not matter if you select this or not.

    • December 30, 2010 at 9:31 pm #31761
      dbremer
      Member
      'peterlaursen' wrote:

      Refer MySQL documentation: http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

      Maybe we should replace LOCAL with NO_WRITE_TO_BINLOG keyword. LOCAL is probably an 'old form' now. But if you do not have binlog enabled and don't use replication it does not matter if you select this or not.

      Thanks, Peter!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.