MySQL 9.1: New Features, Deprecations, and Important Updates
linuxiac, Friday, October 18th, 2024
MySQL 9.1 introduces key updates, including enhanced trigger handling, optimized EXPLAIN output, OpenID Connect support, and more.
MySQL 9.1, a widely adopted open-source RDBMS, is here, bringing improvements, new features, and a few deprecations. Among the most striking novelties is how triggers are handled, particularly during read-only operations.
In earlier versions, triggers associated with a table were fully loaded and parsed each time the table was accessed, even for read-only statements like SELECT. This not only wasted memory but also increased execution time unnecessarily.