Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: flo_turc on November 19, 2008, 06:37:01 PM

Title: Deamon variables at startup
Post by: flo_turc on November 19, 2008, 06:37:01 PM

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.

Title: Re: Deamon variables at startup
Post by: pfloor on November 19, 2008, 09:16:55 PM

Quote from: flo_turc on November 19, 2008, 06:37:01 PM

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

Title: Re: Deamon variables at startup
Post by: flo_turc on November 19, 2008, 10:24:44 PM

config show mysqld

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

Title: Re: Deamon variables at startup
Post by: pfloor on November 19, 2008, 11:39:56 PM

Quote from: flo_turc on November 19, 2008, 10:24:44 PM

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.

Title: Re: Deamon variables at startup
Post by: mmccarn on November 20, 2008, 12:50:59 AM

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