Nov 8, 2018

MySQL performance: turn off binary logs and replication

If you use Gizzard to handle sharding and replication, you can turn off binary logs and replication for higher performance.

show variables like '%sql_log_bin%';
set @@sql_log_bin=0;

You can stop and start the replication of statements on the slave using the STOP SLAVE and START SLAVE statements.

show status;
show slave status;