Hi all, in a previous tread, Cornelia Plott published their my.cnf values for their 16 GB server:
> We had also tuned our MySql DB settings like this: > [mysqld] > ... > #key_buffer = 384M > key_buffer = 2G > #key_buffer_size = 2M > key_buffer_size = 512M > max_allowed_packet = 16M > table_cache = 512 > #sort_buffer_size = 2M > sort_buffer_size = 16M > #read_buffer_size = 2M > read_buffer_size = 64M > #read_rnd_buffer_size = 8M > read_rnd_buffer_size = 128M > #myisam_sort_buffer_size = 64M > myisam_sort_buffer_size = 256M > thread_cache_size = 8 > query_cache_size = 32M > ... > > We change the settings like an recommendation from Baron Schwarz "High > performance MySQL: optimization, backups, replication and more". We > don't changed the max_allowed_packet. What would be a good size? I've looked at them and I have noticed, embarrassingly, that we have a lot of room for improvement, as we have a much lower values (probably Debian defaults; I'm not an expert at all) for our 8 GB server. I have been waiting for a follow up from her question about max_allowed_packet, but as I haven't received any, I'd like to ask now. Are Cornelia posted values fine? If they are, I'll try them halving them for our smaller server. Thanks for any input, Ferran
