Description:
When using innodb_dedicated_server on a box with less than 2GB of RAM, only one InnoDB log file is created.
The initial startup works fine, but any subsequent restart fails with InnoDB complaining that it only found one log file.
How to repeat:
- Use a box with less than 2GB of RAM.
- Install MySQL 8.0. At this point, 2 log files are created and MySQL can be restarted.
- Stop MySQL and add innodb_dedicated_server in my.cnf.
- Restart MySQL. This works, but if you look at the data directory, you will now find only one log file.
- Restart MySQL again. This time, it fails and you will get messages like this in the error log:
2020-10-16T09:57:25.133312Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-16T09:57:25.256467Z 1 [ERROR] [MY-012961] [InnoDB] Only one log file found
2020-10-16T09:57:25.256592Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error not found.
2020-10-16T09:57:25.724038Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-10-16T09:57:25.724272Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-10-16T09:57:25.724423Z 0 [ERROR] [MY-010119] [Server] Aborting
Suggested fix:
Make sure at least 2 log files are created, regardless of the hardware specs.
According to https://bugs.mysql.com/bug.php?id=98164 and https://dev.mysql.com/doc/refman/8.0/en/innodb-dedicated-server.html, this is the expected behavior anyway.
