2018.1

Database 1
Depending on the components installed, a database instance is created in a folder called
"connect.database" under the Windows system temp folder. The temp folder is accessible via
the standardized system variable %TMP%.
Usually, folders holding temporary files and folders should be excluded from a virus protection,
because this influences the overall performance of the whole system at all. However the
responsible person for the computer protection has to decide about the monitoring of such
temporary folders following the company guidelines.
Database 2
Another database instance is used by Connect.This is the Connect back-end database. The
path to this folder is stored in the standardized system variable %PROGRAMDATA%. The
Connect back-end database is located in the subfolder "Connect\MySQL".
As this database will be in constant use when Connect is running, virus protection on this folder
and its sub-folders may have a serious impact on the performance of Connect.
Database Considerations
This page describes the different considerations and pre-requisites for the database back-end
used by PrintShop Mail Connect, whether using the MySQL instance provided by the installer,
or pre-existing (external) instance.
Using the MySQL Instance from the Installer
The MySQL Instance provided in the Installation Wizard is already pre-configured with options
to provide the most stable back-end setup.
These are the specific options that have been changed in our version of "my.ini":
l
max_connections = 200 : PrintShop Mail Connect uses a lot of database connections.
This number ensures that even in high volume environments, enough connections will be
available.
l
max_allowed_packet = 500M : In some implementations, especially when using Capture
OnTheGo, large packet sizes are required to allow transferring binary files. This
substantial packet size maximum setting ensures that the data received by PrintShop Mail
Connect will be able to be stored within the database.
Page 17