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.

© 2001-2024 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.