Koozali.org: home of the SME Server

Obsolete Releases => SME Server 8.x => Topic started by: edform on October 14, 2010, 10:09:29 AM

Title: Templates for my.cnf
Post by: edform on October 14, 2010, 10:09:29 AM

One of the things I need the SME server to provide is a database for functions running on the workstations and one function in particular needs higher values for some of the MySQL working parameters than are provided in the default SME install. I need to add the lines...

       key_buffer_size=18M
       myisam_sort_buffer_size=8M

...to the mysqld section of the configuration file my.cnf but, after searching through the template structure in /etc, I cannot find which templates need to be changed.

Can anyone suggest the correct way to add these two lines?

Ed Form

Title: Re: Templates for my.cnf
Post by: Stefano on October 14, 2010, 10:48:18 AM

Ed

I think that those lines can be added everywhere in my.cnf file

so create your custom fragment in /etc/e-smith/templates-custom/etc/my.cnf/ dir (you have to create the dir too), and call it, for example, 011mysetup

I suggest you also to create a NFR for it in bugzilla

Title: Re: Templates for my.cnf
Post by: edform on October 14, 2010, 11:23:30 AM

Quote from: Stefano on October 14, 2010, 10:48:18 AM

I think that those lines can be added everywhere in my.cnf file

so create your custom fragment in /etc/e-smith/templates-custom/etc/my.cnf/ dir (you have to create the dir too), and call it, for example, 011mysetup

I suggest you also to create a NFR for it in bugzilla

Your suggestion worked perfectly. Thank you!

I'm unsure how to go about creating a new feature request; do you mean I should request that a directory and template stubs should be added to the base configuration so that folks would know where to modify it?

Ed Form

Title: Re: Templates for my.cnf
Post by: Stefano on October 14, 2010, 11:31:26 AM

Quote from: edform on October 14, 2010, 11:23:30 AM

Your suggestion worked perfectly. Thank you!

I'm unsure how to go about creating a new feature request; do you mean I should request that a directory and template stubs should be added to the base configuration so that folks would know where to modify it?

Ed Form

you can open a nfr attaching your fragment and asking for including those variables in db

Title: Re: Templates for my.cnf
Post by: edform on October 14, 2010, 01:41:40 PM

Quote from: Stefano on October 14, 2010, 11:31:26 AM

you can open a nfr attaching your fragment and asking for including those variables in db

Ok, done! Bugzilla 6287

Ed Form

Title: Re: Templates for my.cnf
Post by: cactus on October 14, 2010, 08:39:27 PM

For all others willing to tune and optimize their MySQL databases some pointers as where to look at and where to start:

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://lists.mysql.com/mysql/214398