pt-variable-advisor suggests innodb_flush_method O_DIRECT even when ALL_O_DIRECT is specified

Bug #1177881 reported by Ryan Lowe
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Triaged
Undecided
Unassigned

Bug Description

mysql> show global variables like 'innodb_flush_method';
+---------------------+--------------+
| Variable_name | Value |
+---------------------+--------------+
| innodb_flush_method | ALL_O_DIRECT |
+---------------------+--------------+
1 row in set (0.00 sec)

%> ./pt-variable-advisor localhost
...
# NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance.
...

That should be covered by ALL_O_DIRECT

tags: added: pt-variable-advisor
Changed in percona-toolkit:
status: New → Triaged
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.