Load on the slave is relatively light. It averages about 1.0 due to some data
ware house select queries running against it frequently. Previously only the
load on the master seems to have affected our replication lag no matter what
the slave was doing.
In thinking about this a bit more,
Thanks for the information Greg.
Unfortunately modifying the application stack this close to the holiday season
won’t be an option so I’m left with:
1) Trying to optimize the settings I have for the query mix I have.
2) Optimize any long running DML queries (if any) to prevent lag due to