Tag

8.0

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2023 · Databases

New Features and Enhancements in MySQL 8.0

MySQL 8.0 introduces numerous enhancements including InnoDB engine defaults, atomic DDL, instant column addition, CTE support, UTF8MB4 default charset, Clone plugin, resource groups, role management, multi-valued and functional indexes, invisible indexes, descending indexes, SET_VAR syntax, persistent parameters, window functions, online DDL, and improved backup and binlog capabilities.

8.0DatabaseInnoDB
0 likes · 23 min read
New Features and Enhancements in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 1, 2021 · Databases

Understanding MySQL 8.0 Current Password Validation Policy

This article explains MySQL 8.0's new current‑password validation strategies, showing how to enforce old‑password checks per user or globally, with detailed command‑line examples and options to enable, disable, or customize the behavior for enhanced security.

8.0Databasemysql
0 likes · 8 min read
Understanding MySQL 8.0 Current Password Validation Policy
IT Xianyu
IT Xianyu
Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0DatabaseIndexes
0 likes · 7 min read
Key New Features of MySQL 8.0 for Relational Databases
Architecture Digest
Architecture Digest
Sep 13, 2020 · Databases

MySQL 8.0 Version History and New Features

An overview of MySQL 8.0’s release timeline, including major GA versions, and a detailed summary of its new capabilities such as transactional data dictionary, atomic DDL, enhanced security, role support, InnoDB improvements, JSON enhancements, optimizer extensions, backup lock, connection management, and other performance and management features.

8.0FeaturesInnoDB
0 likes · 10 min read
MySQL 8.0 Version History and New Features