D.1.3 The config.properties file

File location

The repository user name and encrypted password are stored in the config.properties file. The following table shows the location of this file on various operating systems:

Table D.3 MySQL Enterprise Monitor: Default path of the config.properties File

Operating System File Location
Windows C:\Program Files\MySQL\Enterprise\Monitor\apache-tomcat\webapps\ROOT\WEB-INF
Linux and Unix /opt/mysql/enterprise/monitor/apache-tomcat/webapps/ROOT/WEB-INF
Mac OS X /Applications/mysql/enterprise/monitor/apache-tomcat/webapps/ROOT/WEB-INF

Make sure that the file is secured at the filesystem level so that it cannot be read by anybody but the administrator, or MySQL Enterprise Monitor.

Usage

A generated config.properties file looks similar to:


#SymmetricKey was auto generated.
#Thu Aug 15 13:35:56 PDT 2013
mysql.use_ssl=true
mysql.user=service_manager
mysql.port=13306
key=8577667A79DF5275
mysql.pass=BMcsacZdrMmM7mrnFExURHDuxp4C3hcrZyxcpC2QhiE\=
mysql.verify_server_cert=false
mysql.server=localhost
mysql.db=mem

Note

The mysql.pass is encrypted.

The application has two connection pools, one to service agent traffic, and the other for the UI. You can configure them as one logical pool with a 85/15 (agent/ui) percentage split, and use "dbPool" as the pool name in the further settings. Or, you can configure each pool separately, where the pool names are "default" and "ui". Note that the names after the "." come verbatim from DBCP at http://commons.apache.org/proper/commons-dbcp/configuration.html.

Table D.4 Optional config.properties values


  • notify_thread_pool_size(4)

    Permitted Values Type integer
    Default 4

    SMTP and SNMP notifications are sent asynchronously, this controls how many threads are used for this process.

  • thread_pool_size(8)

    Permitted Values Type integer
    Default 8

    Used to handle background jobs.

  • data_collection_interval(00:01:00)

    Permitted Values Type string
    Default 00:01:00

    Defaults to one minute, and is never less than one minute. May be set to a value larger than one minute by use of the data_collection_interval property, in hh::mm::ss interval format.

  • internal_perf_enable(false)

    Permitted Values Type boolean
    Default false

    Enables internal performance monitoring for MySQL Enterprise Monitor (requires deploying some graphs from the resources/ directory).

  • internal_perf_server_id(false)

    Permitted Values Type integer
    Default

    If internal_perf_enable is set to true, and MySQL Enterprise Service Manager can not read mysql.inventory, then use this ID instead.

  • quanal.collect(00:01:00)

    Permitted Values Type string
    Default 00:01:00

    The rate that the service manager asks for query analysis data from the agent and plugins. It is expressed using the hh:mm::ss interval format.

  • ui.javascript.useClientSideStorage(false)

    Permitted Values Type boolean
    Default false

    Use this instead of cookies to store UI state (not login, but graph selection, etc.) Generally only needed if using a broken proxy that truncates cookie length.

  • supportReport.retention.minutes(6 hours)

    Permitted Values Type string
    Default 6 hours

    The length of time that MySQL Enterprise Monitor will retain the reports generated when using "Support diagnostics" from "Manage Servers".

  • dbpool.ui.initialSize(5)

    Permitted Values Type integer
    Default 5

  • dbpool.ui.maxActive(15)

    Permitted Values Type integer
    Default 15

  • dbpool.ui.minIdle(0)

    Permitted Values Type integer
    Default 0

  • dbpool.ui.maxIdle(5)

    Permitted Values Type integer
    Default 5

  • dbpool.ui.maxWaitMillis(30 seconds)

    Permitted Values Type string
    Default 30 seconds

  • dbpool.ui.timeBetweenEvictionRunsMillis(5 seconds)

    Permitted Values Type string
    Default 5 seconds

  • dbpool.ui.minEvictableIdleTimeMillis(15 seconds)

    Permitted Values Type string
    Default 15 seconds

  • dbpool.default.initialSize(20)

    Permitted Values Type integer
    Default 20

  • dbpool.default.maxActive(70)

    Permitted Values Type integer
    Default 70

  • dbpool.default.minIdle(0)

    Permitted Values Type integer
    Default 0

  • dbpool.default.maxIdle(5)

    Permitted Values Type integer
    Default 20

  • dbpool.default.maxWaitMillis(30 seconds)

    Permitted Values Type string
    Default 30 seconds

  • dbpool.default.timeBetweenEvictionRunsMillis(5 seconds)

    Permitted Values Type string
    Default 5 seconds

  • dbpool.default.minEvictableIdleTimeMillis(15 seconds)

    Permitted Values Type string
    Default 15 seconds


User Comments
Sign Up Login You must be logged in to post a comment.