Versions Compared

Old Version 11

changes.mady.by.user Samuel Kirby

Saved on

compared with

New Version Current

changes.mady.by.user Samuel Kirby

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagebash
[mysqld]
...
datadir = /var/lib/mysql
...
wait_timeout = 28800
...
binlog_format = mixed
log_bin_trust_function_creators = 1
...
binlog_expire_logs_seconds = 172800
...
innodb_page_size = 64K
...
slow_query_log = 1
long_query_time = 5
log_slow_verbosity = query_plan,explain

...

Code Block
languagebash
innodb_default_row_format = dynamic
innodb_file_per_table = 1
innodb_strict_mode = ONOFF
Note

Check the innodb_buffer_pool_size parameter is set to a suitable size depending on the specification of the server. See MariaDB planning

Bounce MariaDB:

Code Block
languagebash
sudo systemctl stop mysql.service
sudo systemctl start mysql.service

...