[MDEV-25728] mysqld --help --verbose creates a log-bin-index file Created: 2021-05-19  Updated: 2022-09-26  Resolved: 2021-05-19

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2.32
Fix Version/s: 10.6.2, 10.2.39, 10.3.30, 10.4.20, 10.5.11

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None


 Description   

This happens when log-bin is set.

From https://github.com/docker-library/mysql/issues/136 / https://github.com/MariaDB/mariadb-docker/pull/44

root@9ebc054fcde1:/# cat > /etc/mysql/conf.d/test.cnf
[mysqld]
bind-address=0.0.0.0
log-bin=foo-bin
console=1
general_log=1
general_log_file=/var/lib/mysql/mysql-general.log
slow_query_log=1
slow_query_log_file=/var/lib/mysql/mysql-slow.log
log_error=/var/lib/mysql/mysql-error.log
collation-server=utf8_unicode_ci
character-set-server=utf8
binlog_format=ROW
server_id=999
transaction-isolation=READ-COMMITTED
sync_binlog=1
sync_frm=1
log_output=TABLE,FILE
 
root@9ebc054fcde1:/# mysqld --help --verbose | grep general
2021-05-19  3:50:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-19  3:50:27 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
  --general-log       Log connections and queries to a table or log file.
                      mysql.general_logif --log-output=TABLE is used.
  --general-log-file=name 
                      --relay-log-index, --general-log-file,
                      Don't log certain types of statements to general log. Any
                      Log some not critical warnings to the general log
general-log                                                TRUE
general-log-file                                           /var/lib/mysql/mysql-general.log
 
root@9ebc054fcde1:/# mysqld --help --verbose | grep log-bin
2021-05-19  3:50:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-19  3:50:37 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
                      names for --log-bin, --log-bin-index, --relay-log,
  --log-bin[=name]    Log update queries in binary format. Optional argument
  --log-bin-compress  Whether the binary log can be compressed
  --log-bin-compress-min-len[=#] 
  --log-bin-index=name 
  --log-bin-trust-function-creators 
                      If set to FALSE (the default), then when --log-bin is
log-bin                                                    foo-bin
log-bin-compress                                           FALSE
log-bin-compress-min-len                                   256
log-bin-index                                              (No default value)
log-bin-trust-function-creators                            FALSE
 
root@9ebc054fcde1:/# ls -la /var/lib/mysql
total 8
drwxr-xr-x. 2 root root 4096 May 19 03:50 .
drwxr-xr-x. 8 root root 4096 May 13 17:21 ..
-rw-rw----. 1 root root    0 May 19 03:50 foo-bin.index



 Comments   
Comment by Daniel Black [ 2021-05-19 ]

Thanks robertbindar for the review

Generated at Thu Feb 08 09:39:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.