[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
port = 3306
max_connections = 500
wait_timeout = 60
thread_cache_size = 16
skip-name-resolve
tmp_table_size = 256M
max_heap_table_size = 256M
query_cache_size = 128M
query_cache_type = 1
query_cache_limit = 256K
query_cache_min_res_unit= 2k
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 3
innodb_log_file_size = 16M
log_error = /var/log/mysql/error.log
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
myisam-recover-options = BACKUP
expire_logs_days = 10
max_binlog_size = 100M
big-tables
MySQL
hakkında diğer konular