Dear Friends;
I have done a lot of readings and now understand paramters I need to "tweak" for my phpBB forum. I am trying to set my key_buffer to 64M. That's 1/4 of my VSP RAM which is 256MB. If I have the key_buffer under mysqld, mySQL won't start. If I remove that and put it under safe_mysqld; it works. However, when I do the variable check from either command line, or in mysql client: key_buffer_size is pretty much set to 8388600 and it does not change.

Thanks,
Mehmet.

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock


[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
key_buffer= 64M


[mysqldump]
quick
max_allowed_packet=16M


[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M



If anyone cares; site mysql variables and status is here:

http://www.alisamiyen.net/performance/