my.cnf with 12 Gb RAM ?

[SecondSight]

Hello !

My server has got 12 Gb of RAM. This is how I configured my.cnf (I modified the existing my.cnf) :

max_user_connections=1000 max_connections=2000 max_allowed_packet=1M key_buffer_size=3072M sort_buffer_size=24M join_buffer_size=4M read_buffer_size=12M read_rnd_buffer_size=12M max_heap_table_size=128M table_cache=2000 thread_cache_size=1024 tmp_table_size=128M myisam_sort_buffer_size=1024M query_cache_size=1024M query_cache_limit=12M interactive_timeout=60 wait_timeout=100 [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open-files-limit=8192 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] set-variable = key_buffer=256M set-variable = sort_buffer=384M set-variable = read_buffer=16M set-variable = write_buffer=16M [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=384M set-variable = read_buffer=16M set-variable = write_buffer=16M [mysqlhotcopy] interactive-timeout

What do you think of it ?

Thank you ! :)

[mysqld]