MySQL 5.7 was the most popular version of the open source database. But several legacy problems needed to be solved, performance increased, and new features added. The biggest change is a true data dictionary which removes all those odd little files with meta-data (.frm, myi, myd, etc) and provides transactional ALTER TABLEs. Plus you see Invisible Indexes, roles, CTEs/Windowing functions, UTF8MB4 support, and learn what happened to MySQL 6 and MySQL 7.

Comments

Comments are closed.

Ann Gaffigan at 09:42 on 26 Oct 2017

Exciting to hear about the new toys in MySQL 8. Very informative, thanks Dave!

Lots of good information about what's coming up in mySQL 8.