pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is)

Reported by Ryan Lowe on 2013-04-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
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)

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
Daniel Nichter (daniel-nichter) wrote :

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.

Changed in percona-toolkit:
assignee: nobody → Daniel Nichter (daniel-nichter)
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.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers