ILIAS 8 Install Tutorial for Ubuntu 22.04

Configure MariaDB

ILIAS

  • The collation is very important
  • For ILIAS you need collation utf8_unicode_ci or utf8mb3_unicode_ci which is technically the same
  • Do never use utf8mb4
  • nano /etc/mysql/mariadb.conf.d/50-ilias.cnf
  • Add these lines, save  and exit:
[Service]
LimitMEMLOCK=infinity
LimitNOFILE=524288
TimeoutStartSec=600
ExecStartPre=/bin/sync
ExecStartPre=/sbin/sysctl -q -w vm.drop_caches=3
 
innodb_strict_mode=ON 
log_error = /var/log/mysql/error.log
slow_query_log_file    = /var/log/mysql/mariadb-slow.log
long_query_time        = 0.5
log_slow_rate_limit    = 1000
log_slow_verbosity     = query_plan,explain
default_storage_engine  = InnoDB
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 
[mysqld]
max_allowed_packet=512M
innodb_large_prefix=ON
innodb_file_format=barracuda
innodb_file_per_table=ON
default-storage-engine = InnoDB
innodb_log_file_size = 1G
innodb_io_capacity = 2000
innodb_io_capacity = 2000
character-set-server=utf8
collation-server=utf8_unicode_ci
 
 
query_cache_type = 1
query_cache_limit      = 16M
query_cache_size        = 512M
innodb_buffer_pool_size = 60G  # Beispielsweise 2/3 des RAM
server-id = 1
log-queries-not-using-indexes = 1
log_slow_verbosity = query_plan
 
thread_stack = 512K
systemctl restart mariadb
systemctl restart apache2

Take a look at some parameters

  • mysql
  • SHOW VARIABLES;
    • Filter for some:
      • SHOW SESSION VARIABLES LIKE 'max_allowed_packet';
      • SHOW SESSION VARIABLES LIKE 'connect_timeout';
  • exit
  • Example output:


Information Message
No comment has been posted yet.