Mysql : ERROR 1016 (HY000) at line 1: Can’t open file

When creating a large number of partitions or tables, MySQL may mysteriously stop working and you find this type of error on /var/lib/mysql/$HOSTNAME.err:

[ERROR] /usr/sbin/mysqld: Can’t open file: ‘./database/table.frm’ (errno: 24)

errno: 24 simply means that too many files are open for the given process. There is a read-only mysql variable called open_files_limit that will show how many open files are allowed by the mysqld:


A lot systems set this to something very low, like 1024. Unfortunately, the following will NOT work:
SET open_files_limit=100000<

MySQL will respond with:

ERROR 1238 (HY000): Variable ‘open_files_limit’ is a read only variable

However, it is possible to make a change to /etc/my.cnf This file may not exist, if not, just create it. Be sure it has the following contents:

open_files_limit = 100000

Then, be sure to restart mysql:

sudo /etc/init.d/mysql restart

Now, SHOW VARIABLES LIKE ‘open%’ should show 100000. The number you use may be different.

Source :

Menambahkan volume share di docker

Docker tidak akan menyimpan segala perubahan pada container apabila docker shutdown, untuk mengakalinya adalah dengan mounting storage di host ke container, sebgai contoh yg sering mengalami perubahan adalah di folder /var/www dan /var/lib/mysql, untuk itu folder tersebut di simpan di storagenya host, untuk mount volume dari storage ke container lakukan perintah  di bawah ini :

docker run -d -v /data/www:/var/www -v /data/db:/var/lib/mysql -p 80:80 -p 443:443 --name ocshttps7 -it ocshttps2 bash

Ane tidak menjelaskan detail perintah diatas, cuman yg mesti diperhatikan adalah /data/www:/var/www, yang mana /data/www berada di host dan /var/www adalah direktori di container.

Klo paham Alhamdulillah, klo tidak paham maaf ye soale ini buat catatan pribadi saja 🙂