SQL storage for Gentics Mesh

MESH_JDBC_DATABASE_NAME

Override the default database name.

MESH_FIELD_CONTAINER_CACHE_SIZE

Override the field container cache size.

HIKARI_CP_MAX_POOL_SIZE

This property controls the maximum size that the pool is allowed to reach, including both idle and in-use connections. Basically this value will determine the maximum number of actual connections to the database backend. A reasonable value for this is best determined by your execution environment. When the pool reaches this size, and no idle connections are available, calls to getConnection() will block for up to connectionTimeout milliseconds before timing out.

MESH_TX_RETRY_DELAY_SECONDS

Override the default transaction retry delay interval.

MESH_DB_SYNC_WRITES_TIMEOUT

Override the database sync write timeout.

LICENSEKEY

The license key

MESH_JDBC_DRIVER_CLASS

Override the default JDBC driver class.

HIKARI_CP_MIN_IDLE_CONNECTION

This property controls the minimum number of idle connections that HikariCP tries to maintain in the pool. If the idle connections dip below this value and total connections in the pool are less than maximumPoolSize, HikariCP will make a best effort to add additional connections quickly and efficiently. However, for maximum performance and responsiveness to spike demands, we recommend not setting this value and instead allowing HikariCP to act as a fixed size connection pool.

MESH_JDBC_CONNECTION_URL_EXTRA_PARAMS

Add the default JDBC connection URL extra params.

MESH_HIBERNATE_GENERATE_STATISTICS

Set whether hibernate should generate statistics.

MESH_JDBC_DRIVER_CLASSPATH

Set the JDBC drivers classpath.

HIKARI_CP_CONNECTION_TIMEOUT

This property controls the maximum number of milliseconds that a client (that's you) will wait for a connection from the pool. If this time is exceeded without a connection becoming available, a SQLException will be thrown. Lowest acceptable connection timeout is 250 ms.

MESH_JDBC_CONNECTION_URL

Override the default JDBC connection URL.

MESH_HIBERNATE_NATIVE_QUERY_FILTERING

Override the configured native query filtering.

MESH_JDBC_CONNECTION_USERNAME

Set the JDBC connection username.

MESH_HIBERNATE_SECOND_LEVEL_CACHE_ENABLED

Set whether second-level cache should be enabled.

MESH_HIBERNATE_JDBC_BATCH_SIZE

Set batch size. Recommended values are between 5 and 30

MESH_HIBERNATE_QUERY_TIMEOUT

Query timeout for hibernate. Default: 0

MESH_JDBC_RETRY_LIMIT

Override the default transaction retry count.

HIKARI_CP_POOL_NAME

This property represents a user-defined name for the connection pool and appears mainly in logging and JMX management consoles to identify pools and pool configurations.

MESH_DB_SYNC_WRITES

Override the database sync writes flag.

HIKARI_CP_MAX_LIFETIME

This property controls the maximum lifetime of a connection in the pool. An in-use connection will never be retired, only when it is closed will it then be removed. On a connection-by-connection basis, minor negative attenuation is applied to avoid mass-extinction in the pool. We strongly recommend setting this value, and it should be several seconds shorter than any database or infrastructure imposed connection time limit. A value of 0 indicates no maximum lifetime (infinite lifetime), subject of course to the idleTimeout setting. The minimum allowed value is 30000ms (30 seconds).

HIKARI_CP_LEAK_DETECTION_THRESHOLD

This property controls the amount of time that a connection can be out of the pool before a message is logged indicating a possible connection leak. A value of 0 means leak detection is disabled. Lowest acceptable value for enabling leak detection is 2000 (2 seconds).

MESH_HIBERNATE_SHOW_SQL

Set whether the driver-specific SQL queries should be logged.

MESH_DB_EXPORT_DIRECTORY

Override the graph database export directory.

MESH_LIST_FIELD_CACHE_SIZE

Override the list field cache size.

HIKARI_CP_REGISTER_MBEANS

This property controls whether or not JMX Management Beans ("MBeans") are registered or not.

HIKARI_CP_TRANSACTION_ISOLATION_LEVEL

This property controls the default transaction isolation level of connections returned from the pool. If this property is not specified, the default transaction isolation level defined by the JDBC driver is used. Only use this property if you have specific isolation requirements that are common for all queries. The value of this property is the constant name from the Connection class such as TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ. Setting it to null defaults to isolation level defined in the JDBC driver.

MESH_HIBERNATE_EXPOSE_JMX_METRICS

Set whether hibernate should expose jmx metrics

MESH_JDBC_CONNECTION_PASSWORD

Set the JDBC connection password.

LICENSEKEY_PATH

Override the default licence key file path.

MESH_JDBC_DIALECT_CLASS

Override the default JDBC dialect class.

MESH_HIBERNATE_FORMAT_SQL

Set whether the driver-specific SQL queries should be formatted while logged.

HIKARI_CP_AUTOCOMMIT

This property controls the default auto-commit behavior of connections returned from the pool. It is a boolean value.

MESH_DB_SQL_PARAMETERS_LIMIT

Limit the number of SQL parameters in selected lookup queries. Can be either `definedByDatabase` or `unlimited` or a custom number (greater than zero). Default is: definedByDatabase

MESH_HIBERNATE_SLOW_SQL_THRESHOLD

Slow SQL query threshold in milliseconds. Default: 60000

MESH_STALE_TX_CHECK_INTERVAL

Overwrite the interval (in ms) for periodic check for stale transactions.

HIKARI_CP_IDLE_TIMEOUT

This property controls the maximum amount of time that a connection is allowed to sit idle in the pool. This setting only applies when minimumIdle is defined to be less than maximumPoolSize. Idle connections will not be retired once the pool reaches minimumIdle connections. Whether a connection is retired as idle or not is subject to a maximum variation of +30 seconds, and average variation of +15 seconds. A connection will never be retired as idle before this timeout. A value of 0 means that idle connections are never removed from the pool. The minimum allowed value is 10000ms (10 seconds).