MySQL 8.0 Overview

主题: InnoDB, 性能和可扩展性

This presentation covers the new features in MySQL 8.0. In addition to Data Dictionnary and CTEs the presentation covers:

  • Move to utf8(mb4) as MySQL's default character set
  • Language specific case insensitive collation for 21 languages (utf8)
  • Invisible index
  • Descending indexes
  • Improve usability of UUID and IPV6 manipulations
  • SQL roles - SET PERSIST for global variable values
  • Performance Schema, instrumenting data locks
  • Performance Schema, instrumenting error messages
  • Improved cost model with histograms

The presentation ends with Scalability, Plugin infrastructure, and GIS.