Главная
Study mode:
on
1
Intro
2
MySQL 5.6 EOL
3
MySQL 8.0
4
Data Dictionary
5
Optimized for UTF8MB4
6
Hash Joins
7
MySQL as a NoSQL JSON Document Store Database
8
MySQL Shell
9
Invisible Index
10
Invisible Column
11
User Details
12
Binary Log Compression
13
Random Passwords
14
EXPLAIN ANALYZE
15
JSON Document Validation
16
Constraint Checks
17
Histograms
18
CATS
19
Better JSON Support including JSON_TABLEO
20
Common Table Expressions or CTES
21
Window Functions. More granular analysis
22
InnoDB Cluster
23
Replica Set
24
Clone Plugin
25
David Stokes
Description:
Explore the latest features of MySQL 8.0 in this informative 34-minute conference talk by Dave Stokes from Oracle. Learn about the end-of-life for MySQL 5.6, the new data dictionary, UTF8MB4 optimization, and hash joins. Discover MySQL's capabilities as a NoSQL JSON document store database and the introduction of the MySQL Shell. Delve into invisible indexes and columns, enhanced user details, binary log compression, and random password generation. Gain insights on EXPLAIN ANALYZE, JSON document validation, constraint checks, histograms, and improved JSON support including JSON_TABLE. Understand common table expressions (CTEs), window functions for granular analysis, InnoDB Cluster, Replica Set, and the Clone Plugin. This comprehensive overview equips database professionals with knowledge of MySQL 8.0's powerful new functionalities and improvements.

MySQL 8.0 New Features

Linux Foundation
Add to list
0:00 / 0:00