MySQL Configuration
Xpress Insight requires that you supply a schema within an existing MySQL server. Insight requires MySQL v8.0.
Insight does not perform any administration of the MySQL database. Managing the MySQL server and ensuring it is backed up is the responsibility of the customer.
Required Configuration Settings
Insight requires MySQL to have the following options configured:
| Setting | Value | Comments |
|---|---|---|
| max_allowed_packet | 32M | This is the minimum value that should be set. |
| max_connections | This should be set to at least the same value as insight.server.persistence.MySQL.pool-max-size (The default value is 100) |
Performance Related Settings
During operation Insight 5 performs many more insert operations to the database than select operations; When under significant load performance can be improved by using the following settings.
|
Note Performance of the MySQL store varies significantly depending both on the nature of the load and the environment in which MySQL is running so these settings are for guidance only and will need testing in the target environment.
|
| Setting | Value | Comments |
|---|---|---|
| innodb_buffer_pool_size | 70% memory / 10% memory | Follow MySQL advice of either 70% memory (dedicated server) or 10% RAM otherwise |
| innodb_log_file_size | Larger of 2G or innodb_buffer_pool_size | |
| innodb-flush-method | O_DIRECT | (Linux based systems) |
Backing Up the Database
Xpress Insight has no specific requirements for backup and restore of its MySQL database. You should backup the Insight MySQL database in line with your company policy.