서버를 운영하다 보면 binary 로그와 slow-query.log 가 계속해서 쌓이게 됩니다. /etc/my.cnf 파일에 아래 부분을 적용하면 로그 조절이 가능합니다. [mysqld] log-bin=mysql-bin expire_logs_days=7 long_query_time=3 slow_query_log=1 slow_query_log_file=slow-query.log log-bin=mysql-bin 바이너리 로그 파일명을 지정할 수 있습니다. expire_logs-days=7 최근 일주일 분량만 남기는 옵션입니다. long_query_time=3 쿼리타임이 3초를 넘어가면 로그를 남깁니다. slow_query_log=1 슬로우쿼리 로그를 작성하는다는 옵션입니다. slow_query_log_file=slow-query.log 슬로우쿼리 로그 파일명을 지정할 수 있습니다.…
|
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 |