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