3. Database Setup

Owned by Neill Magill
Last updated: Sept 27, 2023

ROGO 7.0.0

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

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 ExamSys on a non MySQL database.

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

The basic default installation config should work for small instances. The my-large.cnf should be suitable for most large instancees.

Consult your DBA and review the MySQL documentation before making any configuration changes.

Make sure the setting default-storage-engine in my.ini is same as the DB engine for ExamSys database. If 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 ExamSys:

 Fine 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:

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

Filter by label

There are no items with the selected labels at this time.