my.cnf settings?? - 03/23/2004 2:11 AM
OK, I read a little bit from the tune thread but thought I might start a new one with my settings.
I didn't realize it but my host overwrites my my.cnf file everytime a config is run, it generates a new my.cnf file, they said I could make it perminate though if I wanted so maybe that is part of my problem, I had no idea that happened.
I have a dedicated linix server, pent III I think with 2 gig of ram, any ideas on what I should change in my.cnf, here are my current settings, like I said above, I guess they have been changing.
# custom vars
set-variable = max_connections=1500
set-variable = join_buffer=1M
num_logs = 28
backup_schedule = 0 2 * * *
updatemode = serial
set-variable = sort_buffer=2M
set-variable = thread_cache_size=50
ns_crit = 1425
server-id = 19976
set-variable = table_cache=3000
set-variable = key_buffer=256M
set-variable = max_connect_errors=10000
set-variable = max_allowed_packet=1M
ns_warn = 1200
set-variable = tmp_table_size=128M
set-variable = record_buffer=2M
I didn't realize it but my host overwrites my my.cnf file everytime a config is run, it generates a new my.cnf file, they said I could make it perminate though if I wanted so maybe that is part of my problem, I had no idea that happened.
I have a dedicated linix server, pent III I think with 2 gig of ram, any ideas on what I should change in my.cnf, here are my current settings, like I said above, I guess they have been changing.
# custom vars
set-variable = max_connections=1500
set-variable = join_buffer=1M
num_logs = 28
backup_schedule = 0 2 * * *
updatemode = serial
set-variable = sort_buffer=2M
set-variable = thread_cache_size=50
ns_crit = 1425
server-id = 19976
set-variable = table_cache=3000
set-variable = key_buffer=256M
set-variable = max_connect_errors=10000
set-variable = max_allowed_packet=1M
ns_warn = 1200
set-variable = tmp_table_size=128M
set-variable = record_buffer=2M