MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
The new features in MySQL 8.0. In addition to Data Dictionnary and CTEs are:
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 following configuration options are available for mysql80-server-8.0.46_3:
====> Permissible Storage Engines (to compile statically into the server)
ARCHIVE=off: Compile "Archive Storage" statically in server
BLACKHOLE=off: Compile "Blackhole Storage" statically in server
EXAMPLE=off: Compile "Example Storage" statically in server
FEDERATED=off: Compile "Federated Storage" statically in server
INNOBASE=off: Compile "InnoDB Storage" statically in server
PARTITION=off: Compile "Partitioning support Storage" statically in server
PERFSCHEMA=off: Compile "Performance Schema Storage" statically in server
====> Default features knobs
PERFSCHM=on: Enable "Performance Schema" by default (High RAM usage)
===> Use 'make config' to modify these settings