Yeah svcprop is a strong command, your advice is really helpful, thanks. /opt/local/etc/my.cnf should be the best configuration path, it can be loaded and meet the smartos rule.
On Feb 15, 2016, at 1:20 PM, Micky <[email protected]<mailto:[email protected]>> wrote: List the services with: svcs Or lookup for mysql or mariadb or perconadb. # svcs | egrep 'mysql|maria|percona' Find the service config with: # svcprop -p config/entities percona file:///opt/local/etc/my.cnf You can also find the service startup command: # svcprop -p start/exec percona /opt/local/lib/svc/method/mysqld\ start On Mon, Feb 15, 2016 at 9:43 AM, 许若辰 <[email protected]<mailto:[email protected]>> wrote: Hi friends, I want to use mysql in smartos zone c540b62c-beb2-11e5-8512-8b1694a57f84 But I find that the default path /opt/local/my.cnf is useless, also I’ve tried /etc/my.cnf /etc/mysql/my.cnf /opt/local/mysql/my.cnf, but none of them work. So how can I configure my mysql? [mysqld] wait_timeout = 14400 mysql> SHOW VARIABLES LIKE 'wait_timeout'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) Thanks. smartos-discuss | Archives<https://www.listbox.com/member/archive/184463/=now> [https://www.listbox.com/images/feed-icon-10x10.jpg1d3216c.jpg?uri=aHR0cHM6Ly93d3cubGlzdGJveC5jb20vaW1hZ2VzL2ZlZWQtaWNvbi0xMHgxMC5qcGc] <https://www.listbox.com/member/archive/rss/184463/27846711-c61ff54c> | Modify<https://www.listbox.com/member/?&;> Your Subscription [https://www.listbox.com/images/listbox-logo-small.png1d3216c.png?uri=aHR0cHM6Ly93d3cubGlzdGJveC5jb20vaW1hZ2VzL2xpc3Rib3gtbG9nby1zbWFsbC5wbmc] <http://www.listbox.com/> ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
