File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree Original file line number Diff line number Diff line change @@ -29,7 +29,7 @@ lc_messages = en_US
2929skip-external-locking
3030collation-server = utf8mb4_unicode_ci
3131init-connect =' SET NAMES utf8mb4'
32- default_character_set = utf8mb4
32+ character_set_client = utf8mb4
3333default_storage_engine = InnoDB
3434performance_schema = OFF
3535
@@ -67,7 +67,7 @@ read_rnd_buffer_size = 256K
6767
6868# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
6969log_error = /var/log/mysql/mysql-error.log
70- log_error_verbosity = 3
70+ log_warnings = 2
7171# Enable the slow query log to see queries with especially long duration
7272slow_query_log = 0
7373slow_query_log_file = /var/log/mysql/mariadb-slow.log
@@ -81,7 +81,7 @@ slow_query_log_file = /var/log/mysql/mariadb-slow.log
8181# auto_increment_offset = 1
8282log_bin = /var/log/mysql/mariadb-bin
8383log_bin_index = /var/log/mysql/mariadb-bin.index
84- binlog_format = ROW
84+ binlog_format = MIXED
8585# sync_binlog = 1
8686binlog_expire_logs_seconds = 604800
8787max_binlog_size = 100M
You can’t perform that action at this time.
0 commit comments