Help Configuring my.ini
 

The forum is running slow so I'm trying to tweak some things.

I'm on a windows 2003 server with dual xeons @ 2.0 ghz. It has 4gb of ram.

Here is what I have now.

HTML Code:
[client]

port=3306

[mysql]

default-character-set=latin1


[mysqld]


port=3306



basedir="C:/Program Files/MySQL/MySQL Server 5.0/"


datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

default-character-set=latin1


default-storage-engine=INNODB


sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=500

query_cache_size=0

table_cache=256

tmp_table_size=103M


thread_cache_size=8

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=205M

key_buffer_size=175M

read_buffer_size=64K
read_rnd_buffer_size=256K

sort_buffer_size=256K



innodb_additional_mem_pool_size=10M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=3499K

innodb_buffer_pool_size=600M


innodb_log_file_size=170M

innodb_thread_concurrency=10
Thanks for the help!