MySQL 5.7, What's New in the Optimizer

Mittwoch, 20. Januar 2016
Themen: Andere

There have been substantial improvements to the optimizer in MySQL 5.7. Most noticeably, users can now combine relational data with NoSQL. MySQL introduced a new JSON datatype & built-in JSON functions, and functional indexes are now supported through both stored and virtually generated columns. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, enable range scans on IN queries with row value expressions, make use of condition filtering, and more. In addition to performance improvements, DBAs will enjoy the ability to run EXPLAIN on a running query as well as the new MySQL query rewrite plugin for handling potential performance regressions. Join this webinar to learn how you can leverage these new features!


  • Manyi Lu, Senior Engineering Manager


Nehmen Sie einfach von Ihrer gewohnten Umgebung, zum Beispiel von Ihrem Büro aus, an diesem Web-Seminar teil.

Zum Webseminar anmelden »

On24-Registrierungsseite wird in einem neuen Reiter/einem neuen Fenster geöffnet