Unable to increase the limit on open MySql files

Question

I changed /etc/mysql/my.cnf as follows

 [mysqld] open-files-limit = 100000 [mysqld_safe] open-files-limit = 100000 

When entering mysql, I do not see any changes to this variable

 mysql> SHOW VARIABLES LIKE 'open%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | open_files_limit | 1024 | +------------------+-------+ 1 row in set (0.00 sec) 

I first tried using open_files_limit but read somewhere that we need to replace the underscore (_) with a dash (-) in this variable

I am using ubuntu 15.10 Any help?

---

I also tried the following things

 http://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit http://serverfault.com/questions/440878/changing-open-files-limit-in-mysql-5-5 

------- A change was also made to the following file

 /etc/mysql/mysql.conf.d/mysqld.cnf # query_cache_limit = 1M query_cache_size = 16M open-files-limit = 15000 # 

Answer 1

If you install Mysql through the synaptic manager, then on the latest version of ubuntu 15.10, increasing open_file_limit from the my.cnf file will not work. You need to make the following changes.

 1. Open /lib/systemd/system/mysql.service as super user 2. Add the following lines to the end of it: LimitNOFILE=infinity LimitMEMLOCK=infinity 3. Execute sudo systemctl daemon-reload 4. Restart mysql.