pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is)
Bug #1168110 reported by
Ryan Lowe
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Low
|
Daniel Nichter |
Bug Description
pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is):
"The key buffer size is unconfigured."
When in reality, it *is* configured:
mysql> SELECT @@version;
+------------+
| @@version |
+------------+
| 5.6.10-log |
+------------+
1 row in set (0.06 sec)
mysql> SHOW GLOBAL VARIABLES LIKE 'key_buffer_size';
+------
| Variable_name | Value |
+------
| key_buffer_size | 8388608 |
+------
1 row in set (0.06 sec)
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-ryans-bug-1168110
- Daniel Nichter: Approve
-
Diff: 15 lines (+3/-3)1 file modifiedbin/pt-variable-advisor (+3/-3)
tags: | added: mysql-5.6 pt-variable-advisor |
Changed in percona-toolkit: | |
milestone: | none → 2.2.3 |
status: | New → Confirmed |
Changed in percona-toolkit: | |
importance: | Undecided → Low |
Changed in percona-toolkit: | |
status: | Confirmed → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
The output/advice is correct, it just reads strangely. I've changed it to:
# WARN key_buffer_size: The key buffer size is set to its default value, which is not good for most production systems.