[client]
port=3306
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
port=3306
server_id=1
basedir="X:/UPUPW/MariaDB/"
datadir="X:/UPUPW/MariaDB/data/"
tmpdir="X:/UPUPW/MariaDB/data/"
log-error="X:/UPUPW/MariaDB/data/mariadb.log"
slow-query-log-file="X:/UPUPW/MariaDB/data/mariadb_slow_query"
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
skip-character-set-client-handshake=true
default-storage-engine=MYISAM
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
interactive_timeout=120
wait_timeout=120
log_warnings=1
slow_query_log=0
long_query_time=2
local-infile=0
skip-external-locking
#skip-innodb
#skip-name-resolve
#skip-networking
#enable-named-pipe
#bind-address=127.0.0.1
#log-bin=mysql-bin
#binlog_format=mixed
max_connections=1000
key_buffer_size=64M
sort_buffer_size=512kb
read_buffer_size=1M
join_buffer_size=2M
read_rnd_buffer_size=4M
max_allowed_packet=16M
table_open_cache=256
tmp_table_size=64M
max_heap_table_size=64M
thread_cache_size=16
myisam_max_sort_file_size=64G
myisam_sort_buffer_size=32M
innodb_buffer_pool_size=128M
innodb_log_file_size=256M
innodb_log_buffer_size=8M
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=1
innodb_flush_method=normal
innodb_thread_concurrency=0
innodb_lock_wait_timeout=120
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer_size=2M
write_buffer_size=2M
tmpdir="X:/UPUPW/MariaDB/data/"
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit=8192
