MySQL Production my.conf?

[random1]

Hi All,

 

Is there a MySQL config file for a high end production usage?

 

I am using a quad core, 4GB RAM dedicated Windows server.

 

I currently have my.conf as:

 

# Custom Production MySQL Config
[client]
port = 3306
socket = "C:/xampp/mysql/mysql.sock"
[mysqld]
port = 3306
skip-locking
skip-federated
skip-symbolic-links
max_connections = 500
secure_auth = 1
local-infile = 0
thread_cache_size = 25
query_cache_type = 1
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/xampp/mysql/data"
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 2048
wait_timeout = 1800
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
character_set_server = utf8
delay_key_write = OFF
key_buffer_size = 32M
query_cache_size = 500M
query_cache_limit = 1048576
innodb_data_home_dir = "C:/xampp/mysql/"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/"
innodb_buffer_pool_size = 32M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 10M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
sort_buffer_size = 20M
[mysqlhotcopy]
interactive-timeout

 

I am using the InnoDB engine and UTF8 char set.

 

Are there any more high end server configuration variables that should be set?