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: MySQL
| PS: If you've benefit from this blog, you can support it by making a small contribution. |
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! :)