In my experience that’s only true for very simple queries which play to MySQL’s strongest points, not complex ones or under high transaction volume. I haven’t found that to be a good win since the 2000s because caches usually soak up the easy queries and as your app gains complexity you hit performance cliffs which are harder to deal with, especially without some of the more advanced SQL features. MySQL 8 seems to have improved in this regard.