1#@!#!123s

: / etc /
Filename : my.cnf
back
[mysqld]
disable-log-bin=1
default-authentication-plugin=mysql_native_password
performance-schema=0
log-error=/var/log/mysqld.log
mysqlx=0
innodb_file_per_table=1 # Ensure that each innodb table is it's own binary data block just in case there's corruption.
thread_cache_size=4 # can be increased on servers with large numbers of active users
key_buffer_size=32M
max_allowed_packet=268435456
table_open_cache=512
wait_timeout=300 # can be increased if using persistent connections
max_user_connections=25
open_files_limit=40000


myisam_sort_buffer_size=8M # can be increased per sessions if needed for alter tables (indexes, repair)

#join_buffer_size=2M # leave at default unless there is a good reason
#sort_buffer_size=2M # leave at default unless there is a good reason
#read_rnd_buffer_size=256K # leave at default unless there is a good reason
#read_buffer_size=2M # leave at default unless there is a good reason

collation_server=utf8_unicode_ci
character_set_server=utf8

innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_thread_concurrency=2 # Number of physical + virtual CPU's, be careful of adding more

tmp_table_size=768M
max_heap_table_size=768M
max_connections=150 # Should be between 100-150, increase *slowly* because it causes MySQL to consume more memory!

table_definition_cache=512 # increase by the same factor as table_open_cache
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=64M

general_log=0
slow_query_log=0
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;

innodb_io_capacity=100