[mysql]
#innodb_force_recovery = 1
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = utf8

[mysqld]
#unix_socket=OFF
core-file
port = 3306
user = mysql
default-storage-engine = MyISAM
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysql.pid
#mysqlx = 0
character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"
#skip-character-set-client-handshake

skip-external-locking
#flush

#default_password_lifetime = 0
default_authentication_plugin = mysql_native_password
#default
#sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#my
#sql_mode = ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#sql_mode = NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

skip-name-resolve=1

local-infile = 1
#symbolic-links = 0
#explicit_defaults_for_timestamp = 1
#log_timestamps = SYSTEM
performance-schema-instrument = 'memory/%=ON'
tmpdir = /dev/shm #/tmp/
key-buffer-size = 4G #8G #aps
sort-buffer-size = 2M
myisam-recover-options = FORCE,BACKUP
#myisam-sort-buffer-size = 256M #toxa 256M / 128M default
max-allowed-packet = 64M #512M #aps
max-connect-errors = 1000000 #250
datadir = /var/lib/mysql/
tmp-table-size = 4G #32M #8G #toxa 1G
max-heap-table-size = 4G #8G #toxa 1G
join-buffer-size = 2M #2M #toxa 2M
#query-cache-limit = 4M
#query-cache-size = 256M
#query-cache-type = 1
#query-cache-wlock-invalidate = 1

max-connections = 500 #700 #1024 #4096 #aps
max-user-connections = 64 #32 #64 #16 #aps
#max_statement_time = 30

#thread-concurrency = 12 #10 #toxa 12 #deprecated
thread-cache-size = 64 #128 #64 #toxa 128 #aps
open-files-limit = 65536
table-definition-cache = 4096
table-open-cache = 4645 #16384 #10240 #aps
net_read_timeout = 60
net_write_timeout = 60


innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 1
#innodb-flush-log-at-trx-commit = 2
innodb-file-per-table = 1
innodb-buffer-pool-size = 4G #8G
innodb-buffer-pool-instances = 8 #1
innodb-read-io-threads = 4 #1 #toxa 4
innodb-write-io-threads = 4 #1 #toxa 4
innodb-thread-concurrency = 12 #toxa 12
innodb-default-row-format='dynamic'
innodb-large-prefix = 1
innodb-strict-mode = 0

#innodb_buffer_pool_load_abort = 1

disable-log-bin
log-error = /var/log/mysql/ha007.log
slow-query-log = 1
#long-query-time = 20
slow-query-log-file = /var/log/mysql/ha007-slow.log

performance_schema=ON

#performance_schema_max_mutex_classes=0
#performance_schema_max_mutex_instances=0

[mysqldump]
quick
max_allowed_packet = 128M
default-character-set=utf8

[client]
default-character-set=utf8