131 lines
3 KiB
INI
131 lines
3 KiB
INI
[client]
|
|
|
|
plugin_dir = "{root_dir}/modules/{module_name}/lib/plugin"
|
|
host = {module_name}
|
|
port = {port}
|
|
socket = {module_name}
|
|
user = root
|
|
|
|
[mysql]
|
|
|
|
no-beep
|
|
default-character-set = utf8mb4
|
|
local_infile = 1
|
|
|
|
[mysqld]
|
|
|
|
# General Settings
|
|
|
|
basedir = "{root_dir}/modules/{module_name}"
|
|
bind_address = {ip}
|
|
character_set_server = utf8mb4
|
|
collation_server = utf8mb4_unicode_ci
|
|
datadir = "{root_dir}/data/{module_name}/default"
|
|
default_storage_engine = InnoDB
|
|
#default_time_zone = {time_zone}
|
|
explicit_defaults_for_timestamp = 1
|
|
ft_min_word_len = 3
|
|
lc_messages = en_US
|
|
lc_messages_dir = "{root_dir}/modules/{module_name}/share"
|
|
local_infile = 1
|
|
lower_case_table_names = 2
|
|
performance_schema = 0
|
|
pid_file = "{root_dir}/temp/{module_name}.pid"
|
|
plugin_dir = "{root_dir}/modules/{module_name}/lib/plugin"
|
|
port = {port}
|
|
secure_file_priv = "{root_dir}/temp/upload"
|
|
server_id = 1
|
|
socket = {module_name}
|
|
tmpdir = "{root_dir}/temp/{module_name}/default"
|
|
|
|
# Skip Settings
|
|
|
|
skip-grant-tables
|
|
skip-log-bin
|
|
#skip-name-resolve
|
|
#skip-networking
|
|
skip-ssl
|
|
|
|
# Cache Settings
|
|
|
|
query_cache_limit = 256K
|
|
query_cache_size = 32M
|
|
query_cache_type = 1
|
|
|
|
# Connection Settings
|
|
|
|
max_connections = 128
|
|
max_connect_errors = 32
|
|
thread_cache_size = 4
|
|
|
|
# InnoDB Settings
|
|
|
|
innodb_buffer_pool_size = 160M
|
|
innodb_data_file_path = ibdata1:10M:autoextend
|
|
innodb_data_home_dir = "{root_dir}/data/{module_name}/default"
|
|
innodb_file_per_table = 1
|
|
#innodb_force_recovery = 1
|
|
innodb_log_file_size = 32M
|
|
|
|
# Logging
|
|
|
|
general_log = {query_log_level}
|
|
general_log_file = "{root_dir}/logs/{module_name}/query_log.log"
|
|
log_warnings = {log_level}
|
|
#log_queries_not_using_indexes = 1
|
|
#long_query_time = 1
|
|
#slow_query_log = 1
|
|
#slow_query_log_file = "{root_dir}/logs/{module_name}/slow_query_log.log"
|
|
|
|
# MyISAM Settings
|
|
|
|
key_buffer_size = 32M
|
|
myisam_recover_options = backup,force
|
|
aria_recover_options = backup,force
|
|
|
|
# Table Settings
|
|
|
|
table_definition_cache = 4096
|
|
table_open_cache = 4096
|
|
max_heap_table_size = 128M
|
|
tmp_table_size = 16M
|
|
|
|
[aria_chk]
|
|
|
|
datadir = "{root_dir}/data/{module_name}/default"
|
|
tmpdir = "{root_dir}/temp/{module_name}/default"
|
|
|
|
[aria_read_log]
|
|
|
|
tmpdir = "{root_dir}/temp/{module_name}/default"
|
|
|
|
[myisamchk]
|
|
|
|
key_buffer_size = 32M
|
|
tmpdir = "{root_dir}/temp/{module_name}/default"
|
|
|
|
[mysqladmin]
|
|
|
|
no-beep
|
|
default-character-set = utf8mb4
|
|
|
|
[mysqlcheck]
|
|
|
|
default-character-set = utf8mb4
|
|
|
|
[mysqldump]
|
|
|
|
quick
|
|
quote_names
|
|
max_allowed_packet = 32M
|
|
|
|
[mysqlimport]
|
|
|
|
default-character-set = utf8mb4
|
|
|
|
[mysqlshow]
|
|
|
|
default-character-set = utf8mb4
|
|
keys = 0
|
|
show-table-type = 0
|
|
status = 0 |