Jan Walraven
DevOps



Categories:
  • Arduino (2)
  • CSS (3)
  • Docker (10)
  • ESXi (1)
  • Git (4)
  • Javascript (6)
  • Linux (31)
  • Mac (6)
  • Magento (4)
  • Mysql (13)
  • PHP (9)
  • Zend framework 2 (9)
  • Posted on June 25, 2012

    When creating a large number of partitions or tables, MySQL may mysteriously stop working and you find this type of error on (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:

    
    SHOW VARIABLES LIKE 'open%'
    

    The default 1024 is very low.

    Edit your config file and change as following (/etc/my.cnf.d/server.cnf)

    
    [mysqld]
    open_files_limit = 100000