| Bug #49208 | Changes to deprecated variables between versions not handled in MEM | ||
|---|---|---|---|
| Submitted: | 30 Nov 2009 14:01 | Modified: | 9 Jan 2015 16:11 |
| Reporter: | Roger David Nay | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Enterprise Monitor: Advisors/Rules | Severity: | S3 (Non-critical) |
| Version: | All | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[11 Dec 2009 20:50]
Andy Bang
Related to Bug #42663
Description: Rules don't take into account deprecated variables from version 5.0 to version 5.1. As a result, upgrading to 5.1 can give false warning and errors. As an example is the slow query log. The rule expression is: %log_slow_queries% == "OFF" But log_slow_queries is deprecated in 5.1 and "%slow_query_log%" should be looked at. "As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and optionally --slow_query_log_file=file_name to specify a log file name. The --log-slow-queries option is deprecated." How to repeat: Upgrade 5.0 -> 5.1 with the slow query log rule enabled. Suggested fix: Handle deprecated variables, either in the Expression syntax or some other means.