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