Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Bùi Mạnh, [01.08.19 10:21]
- [mysqld]
- user = mysql
- bind_address = 127.0.0.1
- datadir = /var/lib/mysql
- socket = /var/lib/mysql/mysql.sock
- port = 3306
- skip_name_resolve = 1
- max_allowed_packet = 32M
- open_files_limit = 10240
- ###Max_Connection###
- max_user_connections = 10
- ### innodb ###
- default_storage_engine = InnoDB
- innodb_autoinc_lock_mode = 2
- innodb_doublewrite = 1
- innodb_flush_log_at_trx_commit = 1
- innodb_buffer_pool_size = 1536M
- innodb_buffer_pool_instances = 1
- innodb_file_per_table = 1
- innodb_flush_method = O_DIRECT
- innodb_log_buffer_size = 8M
- ### query cache ###
- query_cache_size = 512M
- query_cache_type = 1
- query_cache_limit = 3M
- ### timeout ###
- wait_timeout = 30
- interactive_timeout = 30
- connect_timeout = 30
- ### Redo log
- innodb_log_files_in_group = 2
- innodb_log_file_size = 12M
- ### temporary tables ###
- tmp_table_size = 128M
- max_heap_table_size = 128M
- tmpdir = /var/log/mysql/tmp
- ### thread pool ###
- # I do not use thread pool
- ### thread cache ###
- thread_cache_size = 2
- max_connections = 200
- ### log ###
- log_output = FILE
- log_error = /var/log/mysql/mysql_error.log
- slow_query_log = 1
- log_queries_not_using_indexes = 0
- log_warnings = 2
- long_query_time = 2
- slow_query_log_file = /var/log/mysql/mysql_slow.log
- general_log = 0
- general_log_file = /var/log/mysql/mysql_general.log
- [mysqld_safe]
- log-error=/var/log/mysql/mysqld.log
- #pid-file=/var/run/mysql/mysqld.pid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement