Bug #99187 PLUGIN_VAR_OPCMDARG is more better for innodb_dedicated_server
Submitted: 6 Apr 2020 7:14 Modified: 6 Apr 2020 7:27
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[6 Apr 2020 7:14] Tsubasa Tanaka
innodb_dedicated_server has PLUGIN_VAR_RQCMDARG but PLUGIN_VAR_OPCMDARG is more better.

Other InnoDB options which returns MYSQL_SYSVAR_BOOL are having PLUGIN_VAR_OPCMDARG.

For example, innodb_undo_log_truncate has PLUGIN_VAR_OPCMDARG and we can turn-on this parameter using both of `--innodb-undo-log-truncate=ON` and `--innodb-undo-log-truncate`.

How to repeat:
$ bin/mysqld --no-defaults --datadir=/tmp/test --innodb-dedicated-server
2020-04-06T07:07:44.239237Z 0 [ERROR] [MY-000071] [Server] /usr/mysql/8.0.19/bin/mysqld: option '--innodb-dedicated-server' requires an argument.
2020-04-06T07:07:44.239321Z 0 [ERROR] [MY-010746] [Server] Parsing options for plugin 'InnoDB' failed.
2020-04-06T07:07:44.239361Z 0 [ERROR] [MY-010168] [Server] Failed to initialize builtin plugins.
2020-04-06T07:07:44.239422Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-06T07:07:44.240117Z 0 [System] [MY-010910] [Server] /usr/mysql/8.0.19/bin/mysqld: Shutdown complete (mysqld 8.0.19)  Source distribution.

Suggested fix:
See attached patch
[6 Apr 2020 7:15] Tsubasa Tanaka
patch for MySQL 8.0.19

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug99187_innodb_dedicated_server.patch (application/octet-stream, text), 611 bytes.

[6 Apr 2020 7:27] MySQL Verification Team
Hello tanaka-San,

Thank you for the report and feedback.