...
By default, License Statistics uses an embedded MySQL database, which is delivered delivered with the application. The embedded database will be automatically installed and configured until you change your configuration.
...
- Create the database. For example, type the following in the MySQL console:
mysql>
CREATE DATABASE database_name character set latin1 collate latin1_swedish_ciCHARACTER SET charset_name COLLATE collation_name;
where:is the name of the database.Setting Description Example database_name Name of database xformation_licstat charset_name Specifies the default database character set utf8mb4 collation_name Specifies the default database collation utf8mb4_sv_0900_ai_ci Edit the MySQL configuration file and add the options listed below. Performance-related settings can be changed as needed to values that are appropriate for the amount of data License Statistics pushes through the database.
Code Block sql_mode = ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION sort_buffer_size = 8M join_buffer_size = 8M group_concat_max_len = 30000 innodb_buffer_pool_size = 12G innodb_redo_log_capacity = 1024M innodb_rollback_on_timeout = 1 innodb_thread_concurrency = 16 max_connections=500
Restart the MySQL server.
Info Note: Each time you restart the MySQL server, make sure it is reading the ensure it reads the proper configuration file. Edit the following settings in the configuration file (xflicstat.cfg):
Setting Description MYSQL_SERVER MySQL server name or IP address. MYSQL_PORT 3306 (default). MYSQL_USERNAME Username for the account created in the License Statistics database. MYSQL_PASSWORD Password for the account created in the License Statistics database. MYSQL_DATABASE Name of the database created for License Statistics.