0

I'm running on Ubuntu 16.10 (yakkety yak) with MariaDB 10.x and experience the very same issue as Ubuntu 16.04 Server MySql open_file_limit won't go higher than 65536 with one exception, my open file limits is 16364

cat /proc/$(pgrep mysql)/limits | grep files
Max open files            16364                16364                files

I've searched a lot, and followed this guide, but nothing is changing the "Max Open Files" limit at all :(

Is there somebody who know the answer, or might be able to help?

Community
  • 1
Joakim
  • 39
  • 2
  • 7

1 Answers1

4

16K is the limit for LimitNOFILE for MariaDB, so you might want to increase that in the systemd service definition. For more details check this page: https://mariadb.com/kb/en/mariadb/systemd/

jerichorivera
  • 489
  • 1
  • 4
  • 12