Detailed explanation of how to configure multi-threaded master-slave replication from MySQL 5.7 slave nodes Blog
Detailed explanation of MySQL using profile to analyze slow SQL (group left join is more efficient than subquery) Blog