Bug #79207 | relay_log_space_limit cannot be set to larget than 4GB with 64 bit mysql | ||
---|---|---|---|
Submitted: | 10 Nov 2015 14:54 | Modified: | 10 Nov 2015 17:56 |
Reporter: | Tim Smith | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.6.27/5.7 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[10 Nov 2015 14:54]
Tim Smith
[10 Nov 2015 17:08]
MySQL Verification Team
C:\dbs>5.6\bin\mysql -uroot -p Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.27-log MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show global variables like 'relay_log_space_limit'; +-----------------------+------------+ | Variable_name | Value | +-----------------------+------------+ | relay_log_space_limit | 4294967295 | +-----------------------+------------+ 1 row in set (0.00 sec) mysql> SHOW VARIABLES LIKE "%VERSION%"; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.6.27 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.27-log | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | x86_64 | | version_compile_os | Win64 | +-------------------------+------------------------------+ 7 rows in set (0.00 sec)
[10 Nov 2015 17:56]
MySQL Verification Team
Thank you for the bug report. Below the warning on 5.7 log error file: 2015-11-10T17:16:42.732322Z 0 [Warning] option 'relay_log_space_limit': unsigned value 107374182400 adjusted to 4294967295