Bug #103291 | MySQL 2GB RAM innodb_dedicated_server = 1 causes only 1 log file to be created | ||
---|---|---|---|
Submitted: | 12 Apr 2021 17:52 | Modified: | 14 Apr 2021 12:53 |
Reporter: | Adam Cable (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[12 Apr 2021 17:52]
Adam Cable
[12 Apr 2021 17:53]
Adam Cable
And for completeness, error is logged as: [MY-012961] [InnoDB] Only one log file found
[13 Apr 2021 13:04]
MySQL Verification Team
Hi Mr. Cable, Thank you for your bug report. However, we need more data in order to proceed. What exactly is the size of the innodb buffer pool and how many pools are there ???? If you read section 15.8.12 in our Manual, that value should be 2, unless it is some boundary problem.
[13 Apr 2021 13:16]
MySQL Verification Team
Hi, After further evaluation, we decided to verify this bug. Simply, with that setting, it is our responsibility not to set variables to incorrect values. However, your response is still required. Verified as reported.
[13 Apr 2021 13:37]
Adam Cable
Hi, We simply did the following: - Create a VM with 2GB Ram - Installed MySQL server - Set " [mysqld] innodb_dedicated_server = 1 " as the my.cnf file No other settings were set; this one option should auto-configure everything we need. Happy to provide any other information you require. Thanks, Adam
[14 Apr 2021 12:52]
MySQL Verification Team
Hi Mr. Cable, Can you please upload, in this report, the values of all the configuration variables for that instance.
[14 Apr 2021 12:53]
Adam Cable
Hi, As mentioned above - we only had "innodb_dedicated_server = 1" set in our my.cnf file. Thanks.