Back (Current repo: ansible-playbooks)

A repository for remembering ansible how-to as a quick reference. I do not grind yaml daily.
To clone this repository:
git clone https://git.viktor1993.net/ansible-playbooks.git
Log | Download | Files | Refs

zz-local.cnf (696B)


[mysqld]
bind_address = 0.0.0.0

binlog_format = ROW
expire_logs_days = 7

ignore_db_dir = .log
ignore_db_dir = .tmp

innodb_buffer_pool_dump_at_shutdown = 0
innodb_buffer_pool_load_at_startup = 0
innodb_buffer_pool_size = 256G
innodb_doublewrite = 1
innondb_log_file_size = 1G
innodb_log_write_ahead_size = 16K
innodb_page_size = 16k
innodb_monitor_enable = all
innodb_use_atomic_writes = 0
innodb_use_native_aio = 0
max_allowed_packet = 512M

log_bin = .log/binlog
log_error = /var/lib/mysql/.log/error.log
log_slow_verbosity = query_plan,explain

table_definition_cache = 8K
table_open_cache = 64K

transaction_isolation = READ-COMMITTED

userstat = 1

optimizer_use_condition_selectivity = 1