Initializing help system before first use

Minimum MySQL requirements

Xpress Insight requires that you supply a schema within an existing MySQL server. Insight requires MySQL v8.x with vendor support.

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.

Parent Topic Using MySQL with Insight 5

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.