MySQL 8 is a big departure from earlier versions of the most popular database on the web. You can use histograms to radically decrease query time on secondary indexes, use NO WAIT & SKIPPED LOCKED qualifiers to avoid record contention, and use the Contention Aware Transaction Scheduler instances with extreme resource conflicts. All that, and how to use optimizer hints, invisible indexes, and roles!


Comments are closed.