Why is MySQL unable to open hosts.allow/hosts.deny?
- by HonoredMule
I have a storage server running Nexenta (OpenSolaris kernel, Ubuntu userspace) with MySQL on top of a ZFS storage array, using innodb_file_per_table and ulimit -n set to 8K. mysqltuner.pl confirms the file limit and claims there are 169 files.
The following command:
pfiles `fuser -c / 2>/dev/null
indicates one mysqld process having 485…