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. )
My.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
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
log-bin=mysql-bin
log_slow_queries
long_query_time = 2
log_long_format
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
myisam_recover
skip-bdb
server-id = 1
[mysqldump]
quick
max_allowed_packet = 48M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 2000M
sort_buffer_size = 1500M
read_buffer = 10M
write_buffer = 10M
[mysqlhotcopy]
interactive-timeout