| The information on this page refers to License Statistics v6.18 or newer, which upgraded MySQL to v8.0. If you are using an earlier version of License Statistics, please refer to the documentation for releases prior to v6.18. |
By default, License Statistics uses an embedded MySQL database delivered with the application. The embedded database will be automatically installed and configured until you change your configuration.
| Info |
|---|
Although the embedded database is easier to use and more convenient for getting started with License Statistics, we strongly recommend using it only for testing and evaluation purposes. For production environments, using an external database has advantages such as:
|
...
| Info |
|---|
| Note that License Statistics supports only MySQL |
...
| 8. |
...
| 0. |
...
| x. Other versions are not supported. |
...
To use an external database with License Statistics:
- 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:name 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 or replace your existing mysqld configuration file with the MySQL config.ini file included in the License Statistics distribution. These settings are important for performance, because the default mysqld configuration file is not configured for the high volume of
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.
make sure it is reading theInfo 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.