##Backup/Restore SQLDB
# mysqldump -u mickey -pmouse foo_db | gzip -9 > foo_db.sql.gz
# mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
# gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]
[client]
#default-character-set=utf8
[mysqld]
#skip-innodb
# TIM 3 KY TU
ft_min_word_len=3
innodb_buffer_pool_size=64MB
interactive_timeout = 60
wait_timeout = 60
connect_timeout = 60
max_connections = 350
thread_cache_size = 1024
table_cache = 1024
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 512M
key_buffer = 512M
#tmp_table_size = 512M
#max_heap_table_size = 512M
#myisam_sort_buffer_size = 256M
max_allowed_packet = 2400M
#concurrent_insert = 2
#default-character-set = utf8
#collation-server = utf8_unicode_ci
#character-set-server = utf8
tmpdir = /dev/shm
#log-slow-queries = /var/log/mysql-slow.log
#long_query_time = 5
# InnoDB
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
[mysql]
#default-character-set=utf8
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16000M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M