You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 4
Next »
ROGO 7.0.0
Below is a guide on how to install a database for the latest version of Rogō.
MySQL is currently the only supported database. However, in theory MariaDB should also be compatible. Please let us know if you do successfully run Rogō on a non MySQL database.
Minimum required version of MySQL 5.7
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.
The following non default settings may needed to fine tune MySQL for Rogō:
Fine tuning
mysqld settings:
ft_min_word_len | 3 |
key_buffer_size | 384M |
max_allowed_packet | 16M |
thread_stack | 256K |
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:
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 |
Related articles
Filter by label
There are no items with the selected labels at this time.