Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- datadir = /var/lib/mysql
- log-error = /var/log/mysql/error.log
- slow_query_log_file = /var/log/mysql/slow.log
- local_infile=0
- skip-name-resolve
- explicit_defaults_for_timestamp = 1
- log_timestamps = SYSTEM
- symbolic-links= 0
- big-tables
- innodb_large_prefix=true
- innodb_file_per_table=1
- thread_cache_size = 8
- myisam_sort_buffer_size = 64M
- read_rnd_buffer_size = 8M
- read_buffer_size = 2M
- sort_buffer_size = 2M
- table_open_cache = 512
- max_allowed_packet = 1M
- key_buffer_size = 64M
- innodb_lru_scan_depth = 256
- innodb_log_file_size = 100M
- innodb_buffer_pool_size=4096M
- innodb_thread_concurrency = 0
- innodb_buffer_pool_instances=64
- log_error_verbosity = 3
- query_cache_size = 32M
Advertisement
Add Comment
Please, Sign In to add comment
