Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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

Environment

None

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:03 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

C W June 3, 2024 at 1:58 PM

that is tricky, since you will need to exceed those limits

Roughly:

  • install MySQL

  • determine levels of the limits applied by systemd

  • set MySQL configuration to setting higher than that

  • perform an operation that opens more files

Perhaps MS DBAs, Sveta, etc can give you a better idea about this?

Cc

C W June 3, 2024 at 1:54 PM

the settings are for MySQL, not a version.

C W June 3, 2024 at 1:46 PM

this is an old ticket, so have you checked whether or not the newer releases need the settings too?

Lalit Choudhary December 27, 2018 at 11:45 AM

Thank you for the report.

 

Won't Do

Details

Assignee

Reporter

Labels

Components

Priority

Smart Checklist

Created January 24, 2018 at 9:40 AM
Updated March 4, 2025 at 9:03 PM
Resolved March 4, 2025 at 9:03 PM