Bug #21693 variable report_host is nor listed within show variables nor show slave status
Submitted: 17 Aug 2006 10:11 Modified: 28 Aug 2006 11:03
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0.24 OS:Any (n.a.)
Assigned to: CPU Architecture:Any

[17 Aug 2006 10:11] Oli Sennhauser
Description:
The variable report_host is not listed within show variables nor shown with show slave status.

In addition the output of show slave hosts seems to be wrong neighter slave nor master are running on displayed port 3306!!!

How to repeat:
slave> show global variables like 'report%';
Empty set (0.00 sec)

slave> show slave status\G
master> SHOW SLAVE HOSTS;
+-----------+----------------+------+-------------------+-----------+
| Server_id | Host           | Port | Rpl_recovery_rank | Master_id |
+-----------+----------------+------+-------------------+-----------+
| 28        | Site03 slave a | 3306 | 0                 | 131       |
+-----------+----------------+------+-------------------+-----------+

# on slave
# cat my.cnf | grep report
report_host           = 'Site03 slave a'

slave> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3328  |
+---------------+-------+

master> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3313  |
+---------------+-------+

Suggested fix:
add report_host to show variables output and fix the port in show slave hosts.
[28 Aug 2006 11:03] Valeriy Kravchuk
Thank you for a reasonable feature request.
[9 Jan 2012 13:17] MySQL Verification Team
About the comment:

"In addition the output of show slave hosts seems to be wrong neighter slave nor master are running on displayed port 3306!!!"

I filed internal bug report for this:
Bug 13333431 - INCORRECT DEFAULT PORT IN 'SHOW SLAVE HOSTS' OUTPUT