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)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any

[6 Apr 2020 7:14] Tsubasa Tanaka

Description:
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.

regards,
Umesh