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? Apache

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