Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
5.5.29
-
None
-
None
-
CentOS 6.3
Description
Using as data directory a partition mounted like
[root@mysql mysql]# cat /etc/fstab | grep data
UUID=63de9746-cda7-45f2-b397-7a25ca4ff8be /data ext4 defaults,noatime,nodiratime,noacl,data=journal 1 2
Will result in:
130209 12:37:54 InnoDB: Failed to set O_DIRECT on file ./a/b.ibd: CREATE: Invalid argument, continuing anyway
130209 12:37:54 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662
For every InnoDB table (even for innodb_data)
130209 12:29:41 InnoDB: Failed to set O_DIRECT on file ./innodb_data: OPEN: Invalid argument, continuing anyway
130209 12:29:41 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662
Based on the comments above, I'm closing it as "won't fix" (which relates to the warning text which we would like to keep in sync with the one in MySQL version for now; the rest is not a bug).
I don't have a good suggestion for a better wording for the warning; if you do, please either submit a report for MySQL, or add it here so we could file it on your behalf. Please note however that the warning should not be too verbose since it already floods the error log as it is.
On the documentation side, I have added a comment to our mysqld options page in the KB:
https://kb.askmonty.org/en/mysqld-options-full-list/#comment_481