Bug #43980 Access location of Binary Logs impossible through SHOW statement or I_S
Submitted: 31 Mar 2009 10:57 Modified: 31 Mar 2009 11:04
Reporter: Kai Voigt Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.0, 5.1, 6.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[31 Mar 2009 10:57] Kai Voigt
Description:
When configuring log-bin option in my.cnf, there's no way to ask the running server what the location is of the configured value through a SHOW command or information_schema.

There's @@general_log_file and @@slow_query_log_file, but nothing similar for the bin logs.

How to repeat:
Configure "log-bin=/tmp/log-bin" in [mysqld] and restart the server. Do a "mysql -e 'show variables'|grep tmp" to see there's no variable holding that value.

Suggested fix:
Implement a @@bin_log_basename variable to obtain through I_S and SHOW VARIABLES.
[31 Mar 2009 11:04] Susanne Ebrecht
Verified as described by using actual bzr tree for 5.1 and 6.0