Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3466

LP #1590724: Open file-related variables fail using systemd

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Packaging

      Description

      **Reported in Launchpad by Ceri WIlliams last update 04-07-2016 08:24:26

      2 settings needed to be added to the unit file for PS 5.7 on Debian Jessie to honour:

      • open_files_limits
      • table_open_cache
      • max_connections

      A server went up in production with settings that were unexpected.

      Changes made to /lib/systemd/system/mysql.service:

      LimitNOFILE=infinity
      LimitMEMLOCK=infinity

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: