Bug #79033 Could you confirm document for log-warnings on MySQL5.7GA
| Submitted: | 30 Oct 2015 12:25 | Modified: | 4 Jan 2016 13:18 |
|---|---|---|---|
| Reporter: | Shinya Sugiyama | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
| Version: | 5.7.9,5.7.10 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[30 Oct 2015 12:25]
Shinya Sugiyama
[30 Oct 2015 13:42]
MySQL Verification Team
Thank you for the bug report. C:\dbs>5.7\bin\mysqld --no-defaults --verbose --help | findstr log-warnings -W, --log-warnings[=#] log-warnings 0 C:\dbs>5.7\bin\mysqld --version 5.7\bin\mysqld Ver 5.7.10 for Win64 on x86_64 (Source distribution PULL: 2015-OCT-24)
[2 Nov 2015 18:23]
Paul DuBois
From the source (sql/sys_vars.cc):
static Sys_var_ulong Sys_log_warnings(
"log_warnings",
"Log some not critical warnings to the log file",
GLOBAL_VAR(log_warnings),
CMD_LINE(OPT_ARG, 'W'),
VALID_RANGE(0, 2), DEFAULT(2), BLOCK_SIZE(1), NO_MUTEX_GUARD,
NOT_IN_BINLOG, ON_CHECK(0), ON_UPDATE(update_log_warnings),
DEPRECATED("log_error_verbosity"));
Looks like the default is 2.
And that's what I get as well:
mysql> select @@log_warnings;
+----------------+
| @@log_warnings |
+----------------+
| 2 |
+----------------+
1 row in set, 1 warning (0.00 sec)
However, note the warning:
mysql> show warnings\G
*************************** 1. row ***************************
Level: Warning
Code: 1287
Message: '@@log_warnings' is deprecated and will be removed in a future release. Please use log_error_verbosity instead
1 row in set (0.01 sec)
It could be that the output from mysqld --help is misleading in this case; perhaps the variable is initialized differently at runtime from what gets displayed for a --help-only execution.
[4 Nov 2015 11:01]
Tsubasa Tanaka
@Shinya I found log_error_verbosity is set as 1 (and log_warnings is set as log_error_verbosity - 1) in get_options function when "--help" option is given. https://github.com/mysql/mysql-server/blob/b4104b21520be032400b768cea09a867068be49d/sql/my... So, log_warnings's default value is exactly 2. Just "mysqld --no-defaults --help --verbose" can't report log_warnings (and log_error_verbosity) 's implicit default value. ``` $ bin/mysqld --no-defaults --help --verbose | egrep "log-error-verbosity|log-warnings" --log-error-verbosity=# -W, --log-warnings[=#] log-error-verbosity 1 log-warnings 0 ```
[4 Jan 2016 13:18]
Shinya Sugiyama
[Remind] Change Category from "MySQL Server: Documentation" to "MySQL Server: General". This is not a documentation bug but "--help" option for mysqld command. It is not fixed in MySQL5.7.10. [root@misc01 mysql]# bin/mysql -u root -p -e "select @@version" Enter password: +-------------------------------------------+ | @@version | +-------------------------------------------+ | 5.7.10-enterprise-commercial-advanced-log | +-------------------------------------------+ [root@misc01 mysql]# bin/mysqld --no-defaults --help --verbose | egrep "log-error-verbosity|log-warnings" --log-error-verbosity=# -W, --log-warnings[=#] log-error-verbosity 1 log-warnings 0 [root@misc01 mysql]#
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.