Jump to content


Photo

What Is The Local Checkbox In Table Diagnostics


  • Please log in to reply
1 reply to this topic

#1 stccorp

stccorp

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 25 January 2017 - 08:54 PM

what is the LOCAL checkbox in table diagnostics

 

Is not in the documentation

 

Thank you



#2 Sibin A S

Sibin A S

    Advanced Member

  • Admin
  • PipPipPip
  • 105 posts
  • Gender:Male

Posted 30 January 2017 - 07:11 AM

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 >> 
 
 
Regards,
Sibin





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users