Open sidebar
[client] port = %mysqlport% character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysql] character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" no-auto-rehash no-beep [mysqld] #skip-character-set-client-handshake #skip-name-resolve sql-mode="NO_BACKSLASH_ESCAPES,NO_ENGINE_SUBSTITUTION" #sql-mode="NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" %log%general_log = 1 %log%general_log_file = "%dprogdir%\\userdata\\logs\\%mysql_driver%_queries.log" back_log = 100 basedir = "%dprogdir%\\modules\\database\\%mysql_driver%" bind-address = %ip% #binlog_row_event_max_size=8K bulk_insert_buffer_size = 2M character-set-server=%sqlchr% character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" collation-server=%mysqlcharset% connect_timeout = 5 datadir = "%dprogdir%\\userdata\\%mysql_driver%" default-storage-engine=InnoDB expire_logs_days = 2 explicit_defaults_for_timestamp = TRUE flush_time=0 ft_min_word_len=4 init-connect="SET NAMES %sqlchr%" interactive_timeout=30 join_buffer_size = 1M key_buffer_size = 25M local-infile=0 log-error = "%dprogdir%\\userdata\\logs\\%mysql_driver%_error.log" lower_case_table_names = 2 max_allowed_packet = 2G max_connect_errors = 10 max_connections = 30 max_heap_table_size = 25M max_tmp_tables = 25 myisam-recover-options=backup,force myisam_max_sort_file_size = 256M myisam_repair_threads = 1 open_files_limit=4110 pid_file = "%dprogdir%\\userdata\\temp\\mysql.pid" port = %mysqlport% query_cache_limit = 256K query_cache_size=25M query_cache_type=1 read_buffer_size=2M read_rnd_buffer_size=4M server-id = 1 skip-external-locking skip-innodb_adaptive_hash_index sort_buffer_size = 1M table_definition_cache = 1024 table_open_cache = 1024 thread_cache_size = 286 tmp_table_size = 25M tmpdir = "%dprogdir%\\userdata\\temp" transaction-isolation = READ-COMMITTED wait_timeout=60 #innodb_fast_shutdown innodb_file_per_table = 1 #innodb_force_recovery=1 #skip-innodb_doublewrite innodb_file_format = Barracuda #sql_mode=NO_BACKSLASH_ESCAPES,NO_AUTO_VALUE_ON_ZERO innodb_strict_mode=ON innodb_buffer_pool_instances=8 innodb_buffer_pool_size = 2G innodb_checksum_algorithm=0 innodb_concurrency_tickets=5000 innodb_data_file_path = ibdata1:10M:autoextend innodb_data_home_dir = "%dprogdir%\\userdata\\%mysql_driver%" innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 30 innodb_log_buffer_size = 8M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb_old_blocks_time=1000 innodb_read_io_threads = 8 innodb_stats_on_metadata=0 innodb_thread_concurrency=4 innodb_write_io_threads = 8 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 50M sort_buffer_size = 50M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 2048
Close sidebar
Back
Please note that all pasted data is publicly available.
Twitter
GitHub
Use setting
Back
Please note that all pasted data is publicly available.
Twitter
GitHub
Use setting