The Wahyudiharto's Blog

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

When you use Windows emulator running on Linux such as Wine or CrossOver for the first time, perhaps you may seen a message box said that a Mozilla ActiveX browser object control has missing or not installed.



This may occurs since the emulator engine could not find any library around the environment especially for the internet browser. Make sure that you have all the object required installed properly for the specified case or simply install Internet Explorer 6 to solve the problem as fast as possible.

Labels: CrossOver, Linux