Optimized permanent minimization in MySQL 8.0

Optimized permanent minimization in MySQL 8.0

WHAT IS “OPTIMIZATION OF CONSTANT COLLAPSE”?

  • The goal is to speed up execution by spending a little more time on analysis.
  • Always true and false comparisons are detected and eliminated.
  • In other cases, the type of constant is configured to match the field type if they do not match, thus avoiding type conversion at runtime.

Deploy MySQL 8.0.15 and MySQL 8.0.16:

Copy the test table dump file to 8.0.15 and 8.0.16:

Download the test table in instance 8.0.15:

Download the test table to copy 8.0.16:

OLD BEHAVIOR

CURRENT BEHAVIOR — 8.0.16+

INDEXED COLUMN

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Akademily

Akademily

We conduct reviews, guides and comparative tests of gaming laptops, monitors, graphics cards, keyboards, mouses, headsets and chairs to help you buy the best ga