I want to OPTIMIZE TABLE TABLE in the main library, but I don't want to from the library, can excuse me what method when I perform the main library statement, don't let from library implementation, this statement from library to performed manually, I, I want to own a way:
The set bin - log=off line not line, this way will not affect my other statements from the library?

CodePudding user response:

The set sql_log_bin=0;
Optimize the table... ;
The set sql_log_bin=1;

Sql_log_bin=0 is not to record at your next execution of SQL,