...
- Create the database. For example, type the following in the MySQL console:
mysql>CREATE DATABASE database_name CHARACTER SET charset_name COLLATE collation_name;
where: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, 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.