I want to set the max_allowed_packet setting for mysql (5.1.31) which is running on Solaris 10.
Unfortunately mysql does not seem to read the my.cfg. I tried to place it in /etc/mycfg, /opt/mysql/mysql/data/my.cfg and in /opt/mysql/mysql/support-files/my.cfg.
At each of these locations, the max_allowed_packet does not get set when i check with:
`select @@max_allowed_packet;`
When I start mysqld as such it does set the setting:
# su mysql
$ mysqld --defaults-file=/etc/my.cfg
This are the contents of my.cfg:
[mysqld]
max_allowed_packet = 50M
How can i make mysql read the config when i start it with the SMF tools?