FuqALot

Anyone good with MySQL? I would really appreciate it if anyone could take a quick look at my MySQL my.cnf file and make changes so that the MySQL server will be very fast and will use about 80% of the computer.

The computer info: Dual CPU P4 3.2ghz with 2GB Memory.

[mysqld]
set-variable=wait_timeout=28800
set-variable=max_connections=2500
set-variable=flush_time=5
set-variable=max_connect_errors=100
set-variable=interactive_timeout=10800
set-variable=key_buffer_size=256M
set-variable=join_buffer_size=16M
set-variable=table_cache=5120
set-variable=myisam_sort_buffer_size=32M
set-variable=myisam_max_sort_file_size=2M
set-variable=myisam_max_extra_sort_file_size=256K
set-variable=max_allowed_packet=3M
set-variable=thread_concurrency=4

Thank you very much.