This page describes and explains the required additional MySQL configuration settings for the SNOMED CT example database. For instructions on how to apply these settings see A.3.2 Set Required MySQL Configuration (MacOS) or A.4.2 Set Required MySQL Configuration (Windows).
The following MySQL settings are required for loading and using the SNOMED CT MySQL database.
|local-infile=1||Required to ensure that data can be loaded into the database from local files (e.g. SNOMED CT Release Files)|
mysqld, mysql, client
|ft_stopword_file = ''|
The two settings improve the full text search capabilities of the database.
|ft_min_word_len = 2|
|disable-log-bin||These two settings stop the MySQL server from creating binary log files. Creation of these log files during the import process not only results in substantially slowing of the process but can also generates huge log files that more than double the space required for installation.||mysqld|
The additional configuration settings required are specified in the following way in a file provided in the SnomedRfsMySql/cnf folder.