EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2017 – MySQL 8.0: Major New Features

 | April 25, 2017 |  Posted In: MySQL, MySQL 8.0, Percona Live

PREVIOUS POST
NEXT POST

MySQL 8Breakout sessions are in full swing at the Percona Live Open Source Database Conference 2017. Check out what’s new in MySQL 8.0.

We’ve finished with this morning’s sessions, and this morning saw a lot of amazing open source talks. One of the most well-attended was MySQL 8.0: Major New Features given by Geir Høydalsvik, Senior Software Development Director at Oracle. MySQL is the next major version of the MySQL platform from Oracle, the open source community is expectantly waiting for the official release.

In this session, Geir described many of the new features announced for MySQL 8.0. In addition to Data Dictionary, CTEs and Windows functions, the session covered:

  • 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 ended with some words on scalability, plugin infrastructure, and GIS.

After the talk, Geir was kind enough to speak with me for a minute or so about his talk. Check out the video below to see MySQL’s 8.0 features.

Don’t miss tomorrow’s sessions! You can check out the schedule for tomorrow (4/26) here.

PREVIOUS POST
NEXT POST

Leave a Reply