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 2 reply threads
  • Author
    Posts
    • December 30, 2010 at 3:26 pm #12211
      dbremer
      Member

      When going to Tools->Table diagnostics, next to the Optimize button there is a check-box named Local. There is no description that i can locate in the help that describes the function of the Local check-box.

    • 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 2 reply threads
  • You must be logged in to reply to this topic.