Bug #118010 "Could not increase number of max_open_files to more than 32768"

• Submitted: 18 Apr 9:46
• Modified: 23 Apr 11:55
• Reporter: Support SimpleRezo
• Status: Verified
• Category: MySQL Server: Options
• Severity: S2 (Serious)
• Version: 8.0.39
• OS: FreeBSD (13.3/14.1)
• CPU Architecture: Any

[18 Apr 9:46] Support SimpleRezo

Description:
Trying to setup max_open_files to a value higher than 32768 results in this Warning at startup:

[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 32768 (request: 66046)

Global kernel limits are fine:

# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles
kern.maxfiles: 2095052
kern.maxfilesperproc: 1885545

mysql-user limits also:

# limits -U mysql | grep openfile
  openfiles            infinity

It's probably specific to FreeBSD (bad system limits detection), so that's why I specified the OS.

Link to discussion on FreeBSD forum: <https://forums.freebsd.org/threads/freebsd-14-1-mysql-8-0-39-max-open-files-limit-warning-...>

How to repeat:
Define open_files_limit to a value higher than 32768 on FreeBSD, and start mySQL server.

[23 Apr 11:55] MySQL Verification Team

Thank you for the report