Seitenvergleich

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
sort_buffer_size=1M

innodb_open_files=1048576
open_files_limit=1048576

tmp_table_size=256M
max_allowed_packet=1024M
max_heap_table_size=256M

query_cache_limit=16M
query_cache_size=128M

innodb_lru_scan_depth=128
innodb_ft_max_token_size=84
innodb_ft_result_cache_limit=2000000000
innodb_ft_total_cache_size=640000000
innodb_io_capacity=150000
innodb_io_capacity_max=150000
innodb_open_files=40960
open_files_limit=40960

max_allowed_packet=1073741824

tmp_table_size=128M
max_heap_table_size=128M

query_cache_limit=16777216
query_cache_size=134217728

ssl=1
ssl-ca=/etc/mysql/conf.d/ca.crt.pem
ssl-cert=/etc/mysql/conf.d/server.crt.pem
ssl-key=/etc/mysql/conf.d/server.key.pem

general_log=0
general_log_file=/var/log/mysql/query.log