-
Incident report
-
Resolution: Fixed
-
Trivial
-
None
-
3.2.3
-
None
-
Sprint 2
-
1
Hello,
At percona blog post talking about mysql zabbix db performance:
– tmpdir – sometimes it’s a good idea to point tmpdir to /dev/shm so that on-disk temporary tables are actually written to memory, but there’s one important caveat starting with MySQL 5.5: if you do that, it disables AIO acorss the board, because tmpfs does not support AIO. So I would monitor the activity on current tmpdir (/tmp usually) and only switch it to /dev/shm if I see it being an issue.
At zabbix doc:
for large installations, keeping of MySQL temporary files in tmpfs is recommended
Maybe good idea to say at doc that if you have MySQL > 5.5 you doesn't need tmpfs, or is wrong the percona blog ?
Thank you very much