enterprise-support team mailing list archive

[Agustín <agustin.gallego@xxxxxxxxxxx>]

Added upstream bug related to this.


root@VM-ubuntu14:~# echo "mysql soft nofile 1048576" >> /etc/security/limits.conf
root@VM-ubuntu14:~# echo "mysql hard nofile 1048576" >> /etc/security/limits.conf
root@VM-ubuntu14:~# su mysql --shell /bin/bash --command "ulimit -Hn; ulimit -Sn"
4096
1024
root@VM-ubuntu14:~# echo "open-files-limit=1024000" >> /etc/mysql/mysql.conf.d/mysqld.cnf
root@VM-ubuntu14:~# service mysql stop
...
 * MySQL Community Server 5.7.18 is stopped
root@VM-ubuntu14:~# 
root@VM-ubuntu14:~# mv /var/log/mysql/error.log /var/log/mysql/error.log.bak
root@VM-ubuntu14:~# 
root@VM-ubuntu14:~# service mysql start
..
 * MySQL Community Server 5.7.18 is started
root@VM-ubuntu14:~# cat /var/log/mysql/error.log | grep -C2 "\[Warning\]" | grep open
2017-05-19T18:00:33.161322Z 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1024000)
2017-05-19T18:00:33.161819Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
root@VM-ubuntu14:~# mysql -u root -e "show variables like '%open_files%';"
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| innodb_open_files | 431   |
| open_files_limit  | 1024  |
+-------------------+-------+
root@VM-ubuntu14:~# echo "session required pam_limits.so" >> /etc/pam.d/common-session
root@VM-ubuntu14:~# service mysql stop
...
 * MySQL Community Server 5.7.18 is stopped
root@VM-ubuntu14:~# 
root@VM-ubuntu14:~# mv /var/log/mysql/error.log /var/log/mysql/error.log.bak.2
root@VM-ubuntu14:~# service mysql start
..
 * MySQL Community Server 5.7.18 is started
root@VM-ubuntu14:~# 
root@VM-ubuntu14:~# 
root@VM-ubuntu14:~# cat /var/log/mysql/error.log | grep -C2 "\[Warning\]" | grep open
root@VM-ubuntu14:~# mysql -u root -e "show variables like '%open_files%';"
+-------------------+---------+
| Variable_name     | Value   |
+-------------------+---------+
| innodb_open_files | 2000    |
| open_files_limit  | 1048576 |
+-------------------+---------+
root@VM-ubuntu14:~# mysql -u root -e "show variables like '%version%';"
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.7.18                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| tls_version             | TLSv1,TLSv1.1                |
| version                 | 5.7.18                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+

** Bug watch added: MySQL Bug System #86388
   http://bugs.mysql.com/bug.php?id=86388

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=86388
   Importance: Unknown
       Status: Unknown

** No longer affects: mysql-server

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1673712

Title:
  Open files limit no longer applied after in place upgrade from 5.6 to
  5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/percona-server/+bug/1673712/+subscriptions