Re: extension to TUNING PRODUCTION MySQL SERVER

2002-04-25 Thread Luiz Gustavo
On Fri, Feb 22, 2002 at 11:39:55PM -0800, vijay khanna wrote: > We are going into making the final changes to our > production MySQL server. > production server configuration is > Free BSD PIII dual processor 800 mhz, 750 MB RAM. Are you using MySQL package compiled with linux threads? > Apac

RE: extension to TUNING PRODUCTION MySQL SERVER

2002-03-04 Thread adam nelson
This is what I have on our dual PIII (1.1 Ghz) 1 GB ram [mysqld] set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = table_cache=256 set-variable = key_buffer=128M set-variable = tmp_table_size=16M set-variable = interactive_timeout=7200 set-variable = wait_timeout=240