1
0
mirror of https://github.com/ZotPrime/zotprime.git synced 2021-11-01 23:17:40 +03:00
Files
zotprime-zotero-server/misc/mysql_parameters
Dan Stillman b246748244 Update default MySQL parameters
(Some of these are unnecessary in MySQL 5.7)
2018-02-22 13:42:13 -05:00

27 lines
535 B
Plaintext

universal:
character_set_database = utf8mb4
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
innodb_flush_log_at_trx_commit = 1
innodb_file_format = Barracuda
innodb_large_prefix = 1
log_bin_trust_function_creators = 1
max_allowed_packet = 33554432
max_connect_errors = 10000
sql_mode = STRICT_ALL_TABLES
skip_name_resolve = 1
master:
event_scheduler = ON
max_allowed_packet = 134217728
table_open_cache = 128
wait_timeout = 1800
shard:
max_allowed_packet = 67108864
table_open_cache = 512
wait_timeout = 1800