MySQL 서버설정 참고
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 |
# # This group is read both both by the client and the server # use it for options that affect everything # [client-server] # # include all files from the config directory # !includedir /etc/my.cnf.d [client] # hostname = panel.uhlhosting.ch #default-character-set = utf8mb4 [mysqld] max_allowed_packet=268435456 max_connect_errors = 10 max_connections = 50 #safe-show-database #skip-innodb #skip-locking skip-networking open_files_limit = 25000 local-infile = 0 performance_schema = OFF # Enable logs general-log = ON explicit_defaults_for_timestamp = true # Character collation #character_set_server = utf8mb4 #collation_server = utf8mb4_unicode_ci bulk_insert_buffer_size = 8M connect_timeout = 10 interactive_timeout = 50 query_cache_type = 1 query_cache_limit = M query_cache_min_res_unit = 2k query_cache_size = 0 table_open_cache = 2048 #ft_min_word_len = 2 # Skip reverse DNS lookup of clients # skip-name-resolve thread_stack = 256K transaction_isolation = REPEATABLE-READ read_buffer_size = 2M read_rnd_buffer_size = 16M sort_buffer_size = 8M table_cache = 4096 join_buffer_size = 2M key_buffer_size = 256M max_allowed_packet = 16M read_buffer_size = 2M bulk_insert_buffer_size = 64M default-storage-engine = MYISAM myisam_recover_options = BACKUP,FORCE myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 5G myisam_repair_threads = 4 myisam-recover-options thread_cache_size = 1024 thread_concurrency = 8 max_heap_table_size = 64M tmp_table_size = 64M wait_timeout = 200 innodb_large_prefix = true innodb_file_format = barracuda innodb_file_format_max = barracuda innodb_file_per_table = true innodb_file_per_table = 1 innodb_buffer_pool_size = 3G innodb_buffer_pool_instances = 8 innodb_flush_method = O_DIRECT innodb_io_capacity = 100 innodb_read_io_threads = 8 innodb_thread_concurrency = 16 innodb_write_io_threads = 8 innodb_log_file_size = 256M innodb_fast_shutdown = 1 innodb_additional_mem_pool_size = 16M innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 log-queries-not-using-indexes = 1 # Error log #err-log = /var/log/mysql/error.log binlog_cache_size = 1M # Slow Query Log slow_query_log_file = /var/log/mysql/slow.log long_query_time = 5 # General Log general_log_file = /var/log/mysql/general.log [mysqld_safe] nice = -5 open_files_limit = 8192 [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 16M write_buffer = 16M [mysqldump] # Do not buffer the whole result set in memory before writing it to # file. Required for dumping very large tables quick max_allowed_packet = 16M [mysql] no-auto-rehash # Only allow UPDATEs and DELETEs that use keys. #safe-updates |