[MySQL] open_files_limit를 설정해도 적용안되는 문제

I needed to edit /usr/lib/systemd/system/mysqld.service and add

LimitNOFILE=infinity
LimitMEMLOCK=infinity

Then run systemctl daemon-reload and systemctl restart mysql.service.

Now the variable is capped at 65536 for some reason unknown, but I can live with that for now.

Found this at http://unix.stackexchange.com/questions/152186/mysql-max-open-files-more-than-1024#answer-157910

출처: http://dba.stackexchange.com/questions/86987/mysql-open-files-limit-cannot-change-this-variable

ulimit 명령도 필요없는 듯...