...
- Create the database. For example, type the following in the MySQL console:
mysql>CREATE DATABASE database_name character set latin1 collate latin1_swedish_ci;
where database_name is the name of the database. Edit the MySQL configuration file and add the options listed below. Performance-related settings can be set changed as needed to different values respectively to values that are appropriate for the amount of 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 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.