Topic: Deamon variables at startup

[flo_turc]

Hello All,

I've tried to pass some argument to mysql with the method describe
http://wiki.contribs.org/DB_Variables_Configuration#MySQL_.28mysqld.29

the my.cnf is not modified and arg doesn't pass...

The argument are stored in /home/e-smith/db/configuration but doesn't pass at start up

I could create an template-custom file... But it seams that db is done to create this arg...
thank you, Flo_turc.

[pfloor]

Hello All,

I've tried to pass some argument to mysql

What arguments did you try to pass?  Show the output of:

config show mysqld

[flo_turc]

config show mysqld

mysqld=service
    LocalNetworkingOnly=yes
    key_buffer=16M
    record_buffer=1M
    sort_buffer=4M
    status=enabled
    table_cache=128

[pfloor]

config show mysqld

mysqld=service
    LocalNetworkingOnly=yes
    key_buffer=16M
    record_buffer=1M
    sort_buffer=4M
    status=enabled
    table_cache=128

The bolded options are not configurable via a DB command, the templates are not written for those options.  You will need to create a custom template to set those options.

[mmccarn]

Something like this:

Code: [Select]

mkdir -p /etc/e-smith/templates-custom/etc/my.cnf
cd /etc/e-smith/templates-custom/etc/my.cnf
echo "key_buffer=16M
record_buffer=1M
sort_buffer=4M
table_cache=128" > 012custom_params
expand-template /etc/my.cnf
sv restart mysqld