Page History

...

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.

...

1. 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:

   Setting	Description	Example
   database_name

   is the name of the database.

   	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

2. 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

   
   

3. 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.

   
   

4. 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.