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

Forums | Webyog

Tools to manage and monitor MySQL databases

What Is The Local Checkbox In Table Diagnostics

Tagged: Delhi Pr Agencies, Pr Agency Delhi, Pr Agency in Delhi

This topic has 1 reply, 2 voices, and was last updated 2 years, 8 months ago by treasurebox.

Viewing 1 reply thread

Author

Posts
- January 25, 2017 at 8:54 pm #13582
  
  stccorp
  Member
  
  what is the LOCAL checkbox in table diagnostics
  
  Is not in the documentation
  
  Thank you
- January 30, 2017 at 7:11 am #35821
  
  Sibin A S
  Moderator
  
  Hello,
  
  By default, the server writes OPTIMISE, ANALYZE and REPAIR TABLE statements to the binary log so that they replicate to replication slaves. To suppress logging, you may specify the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. Please refer the official MySQL documentation for the syntax >>
  
  https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
  
  https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
  
  https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
  
  Regards,
  
  Sibin
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.