Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-11638

tmpfs and mysql > 5.5 is still recomend ?

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial 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

            Unassigned Unassigned
            i5513 Javier Barroso
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: