Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # ./mysql-config/my.cnf
- [mysqld]
- #sql-mode = NO_ENGINE_SUBSTITUTION
- max_allowed_packet = 512M
- #query_cache_type = 1
- #query_cache_limit = 1M
- #tmpdir = /tmp
- #tmp_table_size = 290M
- #max_heap_table_size = 290M
- #join_buffer_size = 4M
- innodb_buffer_pool_size = 2G
- innodb_buffer_pool_instances = 2
- #table_cache = 1200
- slow_query_log = 1
- slow_query_log_file = /var/log/mysql/mysql-slow.log
- long_query_time = 1
- bind-address = 0.0.0.0
- group_concat_max_len = 18446744073709551615
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement