I have a server with FreeBSD 4.10 and mySQL 5.0 and
I'm trying to use the my-small.cnf file as my my.cnf file.
I have copied and renamed it to /usr/local/mysql/my.cnf which
is where my BASEDIR referes to.
I have added this to the [mysqld] and [mysqld_safe] sections
open_files_limit = 512
I start mysqld at startup from the rc.local file:
/bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld_safe
--basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ &'
I also tried only:
/bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld_safe --user=mysql &'
But if I look into mysql the open_files_limit stay a the default value,
it seems that the my.cnf ...