Percona Server 5.7 manual is misleading for innodb_flush_method
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Hrvoje Matijakovic |
Bug Description
Manual for Percona Server 5.7 (https:/
"ALL_O_DIRECT: use O_DIRECT to open both data and log files, and use fsync() to flush the data files but not the log files. This option is recommended when InnoDB log files are big (more than 8GB), otherwise there might be even a performance degradation. Note: When using this option on ext4 filesystem variable innodb_
There are two problems with this text.
First, ALL_O_DIRECT does not work, server does not start with this value set and everything else default (unlike in 5.6), see my last comment to https:/
Second is that innodb_
[root@centos ~]# mysql -uroot -e "show variables like 'innodb_log%'"
+------
| Variable_name | Value |
+------
| innodb_
| innodb_
| innodb_
| innodb_
| innodb_
| innodb_
| innodb_
+------
[root@centos ~]# mysql -uroot -e "show variables like 'version%'"
+------
| Variable_name | Value |
+------
| version | 5.7.10-3-log |
| version_comment | Percona Server (GPL), Release 3, Revision 63dafaf |
| version_
| version_compile_os | Linux |
+------
The first problem is tracked at https:/ /bugs.launchpad .net/percona- server/ +bug/1529885.
This bug is then about the second problem, which is a documentation bug.