Details
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
|
Attachments
Issue Links
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Remote Link | This issue links to "mysql bug 78986 (fixed) (Web Link)" [ 31211 ] |
Fix Version/s | 10.6.1 [ 24437 ] | |
Fix Version/s | 10.2.39 [ 25731 ] | |
Fix Version/s | 10.3.30 [ 25732 ] | |
Fix Version/s | 10.4.20 [ 25733 ] | |
Fix Version/s | 10.5.11 [ 25734 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Fix Version/s | 10.6.2 [ 25800 ] | |
Fix Version/s | 10.6.1 [ 24437 ] |
Workflow | MariaDB v3 [ 121984 ] | MariaDB v4 [ 159309 ] |
Thanks robertbindar for the review