Koozali.org: home of the SME Server

Templates for my.cnf

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Templates for my.cnf
« 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

Offline Stefano

  • *
  • 10,836
  • +2/-0
Re: Templates for my.cnf
« Reply #1 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

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: Templates for my.cnf
« Reply #2 on: October 14, 2010, 11:23:30 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

Offline Stefano

  • *
  • 10,836
  • +2/-0
Re: Templates for my.cnf
« Reply #3 on: October 14, 2010, 11:31:26 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

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: Templates for my.cnf
« Reply #4 on: October 14, 2010, 01:41:40 PM »
you can open a nfr attaching your fragment and asking for including those variables in db

Ok, done! Bugzilla 6287

Ed Form

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Templates for my.cnf
« Reply #5 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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)