my.cnf or my.cfg in a cpanel box? and my configs files

Im asking this because ive set a few modifications to the config file i guessed was mysql config, my.cfg but i also have my.cnf in /etc

Here are my settings if someone would like to take a look and point me into a better path my.cnf or my.cfg in a cpanel box? and my configs files.

my.cnf
Code:
[mysqld]
thread_cache_size=50
key_buffer=140M
table_cache=384
sort_buffer_size=2M
read_buffer_size=4M
read_rnd_buffer_size=6M
thread_concurrency=2
my.cfg

Code:
[mysqld]
skip-locking
set-variable = max_connections=250
set-variable = interactive_timeout=60
set-variable = max_user_connections=50
set-variable = wait_timeout=15
set-variable = connect_timeout=15
set-variable = thread_cache_size=286
set-variable = key_buffer=16M
set-variable = max_allowed_packet=16M
set-variable = table_cache=1028
set-variable = sort_buffer=4M
set-variable = record_buffer=1M
set-variable = thread_cache=8
set-variable = thread_concurrency=2
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer_size=1M
set-varibale = read_buffer_size=2M
set-variable = sort_buffer_size=2M
set-variable = tmp_table_size=40M
set-variable = max_connect_errors=10
set-variable = query_cache_limit=1M
set-variable = query_cache_size=32M
set-variable = query_cache_type=1
skip-innodb

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
My server:

p4 2.8ghz
512MB ram
load average: 0.06, 0.10, 0.09

Thanks in advance,

Apocalypse.

 

 

 

 

Top