# # 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
