Sidebar

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

0 votes
625 views
asked Apr 15, 2014 by ben-s-7515 (12,760 points)
edited Mar 13, 2015 by mike-r-7535

2 Answers

0 votes

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)

answered Apr 15, 2014 by ben-s-7515 (12,760 points)
0 votes

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.

answered Aug 11, 2015 by mike-r-7535 (13,830 points)
...