Topic: Templates for my.cnf

[edform]

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

[Stefano]

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

[edform]

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

[Stefano]

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

[edform]

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

Ok, done! Bugzilla 6287

Ed Form

[cactus]

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