Optimized MySQL Configuration File(?)

After try & error with several parameters in my.cnf configuration file, finally below is my version of optimized file.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
max_allowed_packet = 10M

# tambahan optimisasi
skip-locking
skip-innodb
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
interactive_timeout=100
wait_timeout=15
connect_timeout=10
table_cache=512
thread_cache=32
key_buffer = 128M
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2
skip-host-cache
skip-name-resolve

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# tambahan optimisasi
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

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

[mysqlhotcopy]
interactive-timeout

[client]
socket=/var/lib/mysql/mysql.sock

Note that the configuration above has tried on MySQL 4.xx. Comment regarding to this from the reader is needed.

Labels:


PS: If you've benefit from this blog,
you can support it by making a small contribution.

Enter your email address to receive feed update from this blog:

Post a Comment

 

  1. Anonymous Anonymous said,

    Saturday, January 19, 2008 7:11:00 AM

    thanks for sharing! please don't forget to check our new site **Help Save Lives in Africa** when you get time and leave us with your comments. We will appreciate it so much! thanks very much! :)

Post a Comment

Leave comments here...