Features from community MySQL 8.0

The initial release of Aurora MySQL version 3 is compatible with community MySQL 8.0.23. MySQL 8.0 introduces several new features, including the following:

  • JSON functions. For usage information, see JSON Functions in the MySQL Reference Manual.
  • Window functions. For usage information, see Window Functions in the MySQL Reference Manual.
  • Common table expressions (CTEs), using the WITH clause. For usage information, see WITH (Common Table Expressions) in the MySQL Reference Manual.
  • Optimized ADD COLUMN and RENAME COLUMN clauses for the ALTER TABLE statement. These optimizations are called "instant DDL." Aurora MySQL version 3 is compatible with the community MySQL instant DDL feature. The former Aurora fast DDL feature isn't used. For usage information for instant DDL, see Instant DDL (Aurora MySQL version 3).
  • Descending, functional, and invisible indexes. For usage information, see Invisible Indexes, Descending Indexes, and CREATE INDEX Statement in the MySQL Reference Manual.
  • Role-based privileges controlled through SQL statements. For more information on changes to the privilege model, see Role-based privilege model.
  • NOWAIT and SKIP LOCKED clauses with the SELECT ... FOR SHARE statement. These clauses avoid waiting for other transactions to release row locks. For usage information, see Locking Reads in the MySQL Reference Manual.
  • Improvements to binary log (binlog) replication. For the Aurora MySQL details, see Binary log replication. In particular, you can perform filtered replication. For usage information about filtered replication, see How Servers Evaluate Replication Filtering Rules in the MySQL Reference Manual.
  • Hints. Some of the MySQL 8.0–compatible hints were already backported to Aurora MySQL version 2. For information about using hints with Aurora MySQL, see Aurora MySQL hints. For the full list of hints in community MySQL 8.0, see Optimizer Hints in the MySQL Reference Manual.

 

https://dev.mysql.com/blog-archive/the-complete-list-of-new-features-in-mysql-8-0/

 

MySQL :: The complete list of new features in MySQL 8.0

There are over 300 new features in MySQL 8.0. The MySQL Manual is very good, but verbose. This is a list of new features in short bullet form. We have tried very hard to make sure each feature is only mentioned once. Note the similar list for MySQL 5.7. Pl

dev.mysql.com

 

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.3010.html

 

Aurora MySQL database engine updates 2021-11-18 (version 3.01.0, compatible with MySQL 8.0.23) - Amazon Aurora

Thanks for letting us know this page needs work. We're sorry we let you down. If you've got a moment, please tell us how we can make the documentation better.

docs.aws.amazon.com

 

 

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.MySQL80.html

 

 

Aurora MySQL version 3 compatible with MySQL 8.0 - Amazon Aurora

The configuration parameters related to internal temporary tables apply differently to the writer and reader instances in your cluster. For reader instances, Aurora MySQL always uses the TempTable storage engine and a value of 1 for temptable_use_mmap. The

docs.aws.amazon.com

 

 

 

'Real Mysql 8.0 > 02. 설정' 카테고리의 다른 글

Mysql8 시스템 변수  (0) 2022.02.08
Mysql 시스템 변수  (0) 2022.02.08
Mysql convert  (0) 2022.02.08
Mysql convert  (0) 2022.02.08
Mysql version check  (0) 2022.02.08

+ Recent posts