These issues are similar to a comment below. But a lot of these are fixed in recent version of MySQL or handled with Vitess.