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

[Ryan Lowe]

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)

[Daniel Nichter (daniel-nichter)]

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.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-796