Skip to content

Commit 7ddb4ab

Browse files
authored
Update MariaDB Settings
1 parent 2d0f49f commit 7ddb4ab

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

config/etc/mysql/my.cnf

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ lc_messages = en_US
2929
skip-external-locking
3030
collation-server = utf8mb4_unicode_ci
3131
init-connect='SET NAMES utf8mb4'
32-
default_character_set = utf8mb4
32+
character_set_client = utf8mb4
3333
default_storage_engine = InnoDB
3434
performance_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.
6969
log_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
7272
slow_query_log = 0
7373
slow_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
8282
log_bin = /var/log/mysql/mariadb-bin
8383
log_bin_index = /var/log/mysql/mariadb-bin.index
84-
binlog_format = ROW
84+
binlog_format = MIXED
8585
#sync_binlog = 1
8686
binlog_expire_logs_seconds = 604800
8787
max_binlog_size = 100M

0 commit comments

Comments
 (0)