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
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: