Ref 1: https://www.percona.com/blog/how-to-identify-and-cure-mysql-replication-slave-lag/
https://dev.mysql.com/blog-archive/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/