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

0 votes
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.


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).


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)