[MDEV-7110] Add missing MySQL variable log_bin_basename and log_bin_index Created: 2014-11-13  Updated: 2020-09-03  Resolved: 2015-06-09

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.0.14
Fix Version/s: 10.1.6

Type: Bug Priority: Minor
Reporter: Chris Calender (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 7
Labels: None

Attachments: Text File MDEV-7110_KB_v1.txt    
Issue Links:
Blocks
blocks MDEV-7903 xtrabackup SST failing with maria-10.... Closed
Relates
relates to MDEV-18885 log_bin_basename config option is mis... Closed
relates to MDEV-5277 Ensure that all MySQL 5.6 options are... Closed

 Description   

I noticed MariaDB does not have corresponding MySQL system variables:

log_bin_basename and log_bin_index

Without log_bin_basename, there is no way to tell the location and name of the binary log.

This is easily identifiable in MySQL:

mysql> show global variables like 'log_bin%';
+---------------------------------+---------------------------------------------------------------------+
| Variable_name                   | Value                                                               |
+---------------------------------+---------------------------------------------------------------------+
| log_bin                         | ON                                                                  |
| log_bin_basename                | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin       |
| log_bin_index                   | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin.index |

Without these, you can only conform whether binlogging is enabled or not.



 Comments   
Comment by Chris Calender (Inactive) [ 2014-11-13 ]

These variables were not listed in the report below, and it is "closed", hence this new bug report:

https://mariadb.atlassian.net/browse/MDEV-5277

Comment by Elena Stepanova [ 2014-11-14 ]

log-bin-basename is actually listed in MDEV-5277, in the last section "NO_CMD_LINE options", which are said not to be added.

Assigning to svoj who can probably remember why it was decided not to add it, and comment on log_bin_index as well.

Comment by Sergey Vojtovich [ 2015-01-13 ]

MDEV-5277 was supposed to add missing command line options. While these options have NO_CMD_LINE flag, which means they're just system variables without corresponding command line.

MySQL revision-id is mats.kindahl@oracle.com-20101104144352-z7dy7e46jlexdfnw

They should probably be added indeed.

Comment by Sergey Vojtovich [ 2015-02-10 ]

knielsen, could you take this? Upstream patch is a bit more than just adding log_bin_basename and log_bin_index. I'm not sure if those changes are valuable.

Comment by Nirbhay Choubey (Inactive) [ 2015-05-08 ]

http://lists.askmonty.org/pipermail/commits/2015-May/007829.html

Comment by Nirbhay Choubey (Inactive) [ 2015-06-09 ]

Patch:
https://github.com/MariaDB/server/commit/f965cae5fb04a9fd06a939a8f2b52228a62ce9fa

KB entries:

Generated at Thu Feb 08 07:17:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.