Sample my.cnf file
[mysqld] | |
# GENERAL | |
datadir = /var/lib/mysql | |
socket = /var/lib/mysql/mysql.sock | |
pid_file = /var/lib/mysql/mysql.pid | |
user = mysql | |
port = 3306 | |
storage_engine = InnoDB | |
# INNODB | |
innodb_buffer_pool_size = <value> | |
innodb_log_file_size = <value> | |
innodb_file_per_table = 1 | |
innodb_flush_method = O_DIRECT | |
# MyISAM | |
key_buffer_size = <value> | |
# LOGGING | |
log_error = /var/lib/mysql/mysql-error.log | |
log_slow_queries = /var/lib/mysql/mysql-slow.log | |
# OTHER | |
tmp_table_size = 32M | |
max_heap_table_size = 32M | |
query_cache_type = 0 | |
query_cache_size = 0 | |
max_connections = <value> | |
thread_cache_size = <value> | |
table_cache_size = <value> | |
open_files_limit = 65535 | |
[client] | |
socket = /var/lib/mysql/mysql.sock | |
port = 3306 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment