pt-variable-advisor does not consider innodb-plugin
Bug #949961 reported by
Giovanni Bechis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Medium
|
Unassigned |
Bug Description
If innodb-plugin is enabled in MySQL 5.1.x, pt-variable-advisor give a note abot the variable "innodb_
If innodb-plugin is enabled this variable has a different default than with internal innodb storage.
http://
Maybe other parameters have different defaults too.
-------
$ pt-variable-advisor h=host,u=root --ask-pass
Enter password:
# NOTE innodb_
On server I am using MySQL 5.1.61
Giovanni
tags: | added: pt-variable-advisor |
To post a comment you must log in.
Thank you for the bug report. Indeed, the default did change with the plugin, and what we should do is warn if the setting is non-default. We can avoid a lot of complex logic by just testing whether the value is equal to the default in the old or new version, regardless of the actual version running.