Help with my.cnf (8GB Ram)(x64 Mysql)

We have 8GB of ram on our server,
with x64 OS and x64 Mysql. This server
runs only MySql. What we do with
this server is very simple, SELECT and INSERT.
Only two people will use this private server.
It’s not going to be used in public.
Our biggest table is around 3GB.
We want to make the most of that 8GB of RAM.
I posted our my.cnf so anyone tell us
if there are options that you think
is wrong and inappropriate. Million thanks in advance. )


port = 3306
socket = /var/lib/mysql/mysql.sock
port = 3306
socket = /var/lib/mysql/mysql.sock
thread_cache_size = 8
thread_concurrency = 16
back_log = 50
max_connect_errors = 10
table_cache = 2048
max_allowed_packet = 48M
binlog_cache_size = 9M
max_heap_table_size = 1500M
sort_buffer_size = 36M
join_buffer_size = 36M
query_cache_size = 128M
query_cache_limit = 2M
ft_min_word_len = 4
default_table_type = MYISAM
thread_stack = 192K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 2000M
long_query_time = 2
key_buffer_size = 2000M
read_buffer_size = 8M
read_rnd_buffer_size = 48M
bulk_insert_buffer_size = 512M
myisam_sort_buffer_size = 512M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
server-id = 1

max_allowed_packet = 48M


key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

key_buffer = 2000M
sort_buffer_size = 1500M
read_buffer = 10M
write_buffer = 10M


What storage engine do you use? InnoDB or MyISAM?

please guid for Innodb engine how we should set variable on the bases of RAM to improve performance

Hello, thanks for the reply, we use MyISAM tables for the whole database. Thank you )

You can also have a look at in-mysql-server-after-installation/