Question

What options do I need to set in MariaDB/Mysql when installing for QIE?

Answer 1

Outside of the defaults that are used with MariaDB, you will need to set the following option in your my.ini file.

max_allowed_packet=64M

The my.ini file can be found in your MariaDB installation directory.  (To find this you will review the service definition in windows)

Answer 2

I also recommend setting the innodb_log_file_size value.  It must be 10 times larger than your largest record (message record).

innodb_log_file_size=500M

Otherwise, you could get the following exception:

MySQLSyntaxErrorException: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.