Knowledge Base

MySQL Optimized ini File

You can get the MySQL Optimized ini file from below.

[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

You can click for our high-performance virtual servers.