Optimeze MySQL

micron

New member
Joined
Mar 24, 2005
Messages
2
Hello
Please help me optimize my mySQL. I have P4 2.8/512mb/80gb SATA
OS - FreeBSD 4.11
My my.cnf :
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
max_connections = 500
interactive_timeout = 100
wait_timeout = 100
connect_timeout = 10
thread_cache_size = 50
key_buffer = 40M
join_buffer = 1M
max_allowed_packet = 16M
table_cache = 384
record_buffer = 1M
sort_buffer_size = 768K
read_buffer_size = 512K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
max_connect_errors = 10

# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2

#skip-networking
myisam_sort_buffer_size = 64M

# Replication Master Server (default)
# binary logging is required for replication
log-bin

server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M

[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

THANKS
 
Last edited:
but what it is better
thread_cache_size=50
key_buffer=40M
table_cache=384
sort_buffer_size=768K
read_buffer_size=512K
read_rnd_buffer_size=512K

or
thread_cache_size=128
key_buffer=16M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M

?
 
Back
Top