MySQL 8

MySQL is a very popular RDBMS open-source tool used across many web applications especially the ones knows as the LAMP stack. MySQL 8 has been released on 2018 while the support of this version has been scheduled for April 2026.

What is new

  • Data dictionary
  • Atomic data definition statements (Atomic DDL)
  • Upgrade procedure
  • Security and account management
  • Resource management
  • Table encryption management
  • InnoDB enhancements
  • Character set support
  • JSON enhancements
  • Data type support
  • Optimizer
  • Common table expressions
  • Window functions
  • Lateral derived tables
  • Aliases in single-table DELETE statements
  • Regular expression support
  • Internal temporary tables
  • Logging
  • Backup lock
  • Replication
  • Connection management
  • Configuration
  • Plugins
  • C API
  • Additional target types for casts
  • JSON schema validation
  • Multi-valued indexes
  • Hintable time_zone
  • Redo Log Archiving
  • The Clone Plugin
  • Hintable time_zone
  • Hash Join Optimization
  • EXPLAIN ANALYZE Statement
  • Query cast injection
  • Time zone support for TIMESTAMP and DATETIME
  • Precise information for JSON schema CHECK constraint failures
  • Row and column aliases with ON DUPLICATE KEY UPDATE
  • SQL standard explicit table clause and table value constructor
  • Optimizer hints for FORCE INDEX, IGNORE INDEX
  • JSON_VALUE() function
PROS
No user has provided any PROS yet.
CONS
No user has provided any CONS yet.
Please share your experience with us and give us some feedback!
Submit PROS or CONS here!
Overall Rating: 0.0    0 

It is awesome!!  (5/5)
0
I like it  (4/5)
0
It is ok  (3/5)
0
Needs improvement  (2/5)
0
Disappointed  (1/5)
0

0 Comments

Write a comment

Please login Writing comments is only available to subscribed users.
menu
menu