Versions Compared

Key

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

...

Below is a guide on how to install a database for the latest version of RogōExamSys.

Warning

If you have a MySQL expert or database administrator you are recommended to contact them for advice first.

MySQL is currently the only supported database. Please let us know if you do successfully run Rogō ExamSys on a non MySQL database.

See the community release notes for the version of rogo ExamSys you are installing to see the required MySQL version.

...

Make sure the setting default-storage-engine in my.ini is same as the DB engine for Rogo ExamSys database. If rogo ExamSys DB is set to innoDB, change it in my.ini to innoDB.

...

The following non default settings may needed to fine tune MySQL for RogōExamSys:

Expand
titleFine tuning

mysqld settings:

ft_min_word_len

3

key_buffer_size

384M

max_allowed_packet

16M

thread_stack256K

thread_cache_size

8

max_connections

500

query-cache-type

1

query_cache_limit

5M

query_cache_size

500M

max_heap_table_size

536870912

tmp_table_size

536870912

table_open_cache

2500

log-bin

mysql-bin

binlog_format

mixed

innodb settings:


Warning

Not convinced these are improvements on the default settings of mysql 5.7+. So I would only change them if you know what you are doing.


innodb_buffer_pool_size

2000M


innodb_additional_mem_pool_size

200M

deprecated

innodb_log_buffer_size

5M


innodb_flush_log_at_trx_commit

1


innodb_lock_wait_timeout

50


On systems with networked file storage (SANS) with slow disk IO times considerer usinginnodb_flush_log_at_trx_commit = 2. See 'adaptive flushing' for a description of the consequence.

mysqldump settings:

quick


max_allowed_packet

24M


...