Which variables to set under which in my.cnf file

Question

I am a newbie to mysql , Just want to know which variables should i set under which blocks , I mean what variables should be under

[mysql]

What variables under

[mysqld],[mysqladmin],...

and so on

help is appreciated

score 2 · Answer 1 · answered Oct 25 '13 at 06:37

2

You should set all global variables values under [mysqld] section of my.cnf file and restart server to have effect of changed values on your server.

answered Oct 25 '13 at 06:37

Mahesh Patil

1,529
1
11
22

thank you , find can you provide me a link explaining this section – mviswa Oct 25 '13 at 06:42

score 0 · Answer 2 · answered Oct 25 '13 at 06:43

Those blocks are for the different programs within any mysql installation.

For example, the mysqld and mysql groups apply to the mysqld server and the mysql client program, respectively.

You might want to have a look into the manual pages titled "using option files" for more details.

Which variables to set under which in my.cnf file

2 Answers2