Bug #81130 master_info_file is not listed in 'show global variables';

• Submitted: 18 Apr 2016 15:46
• Modified: 18 Apr 2016 19:46
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.7.12
• OS: Any
• CPU Architecture: Any

[18 Apr 2016 15:46] Shane Bester

Description:
How to find out the current value of --master-info-file as a DBA ?

mysql> show variables where variable_name like '%info_file';
+---------------------+---------------+
| Variable_name       | Value         |
+---------------------+---------------+
| relay_log_info_file | slavesss.info |
+---------------------+---------------+
1 row in set (0.01 sec)

Server was started with:
--master-info-file=maaaster.info --relay-log-info-file=slavesss.info

How to repeat:
without filesystem access and without shell access to the server, try determine what file is configured for master-info-file ?

[18 Apr 2016 19:46] MySQL Verification Team

Thank you for the bug report.

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.13 Source distribution PULL: 2016-APR-07

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.7 >
mysql 5.7 > show variables where variable_name like '%info_file';
+---------------------+---------------+
| Variable_name       | Value         |
+---------------------+---------------+
| relay_log_info_file | slavesss.info |
+---------------------+---------------+
1 row in set (0,02 sec)

mysql 5.7 >