This topic is not for all situations but in my situation it
The problem is with Slave is lagging behind master in very large numbers and the relay logs are continously growing.
Slave is using:
But in folder where relay log resides, was created up to:
And it is continously growing.
So what i decide to do, again step-by-step i edited my.cnf file as follows:
1. I have 13 database so give to slave paralel workers
slave-parallel-workers = 13
2. Disabled sync_binlog:
sync_binlog = 0
3. Changed at_trx_commit from 1 to 0:
innodb_flush_log_at_trx_commit = 0
4. Gave log_at_timeout (only from 5.6.6>) to 10:
innodb_flush_log_at_timeout = 10
5. Disabled slow query log( or commented out)
So …[Read more]