Yesterday, MySQL 8.4, the very first LTS version of MySQL was released.
A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications.
The default value of 20 InnoDB variables has been modified!
Let’s have a look at those variables and explain the reason for such modification:
innodb_buffer_pool_in_core_file
| Previous Value: | ON |
| New Value (8.4 LTS): |
OFF if MADV_DONTDUMP is supported else ON |
MADV_DONTDUMP is a macro supported in Linux 3.4 and later, (“sys/mman.h” header file is present and contains the symbol MADV_DONTDUMP, a …
[Read more]