Skip navigation links
C.2 MySQL Enterprise Agent Reference »
Section Navigation      [Toggle]

C.1.5. The config.properties file

File location

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

Table C.5. 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 will look similar to: 

#SymmetricKey was auto generated.
#Wed Feb 27 17:32:14 PST 2013
mysql.port=13306
mysql.user=service_manager
quanal.collect=00\:01\:00
mysql.db=mem
default.maxActive=70
mysql.use_ssl=true
mysql.server=127.0.0.1
mysql.pass=l33t
key=8E15928C7732FA85
mysql.verify_server_cert=false

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 C.6. Optional config.properties values

Property Name Property Type Default
data_collection_interval string 00:01:00
dbpool.default.initialSize integer 20
dbpool.default.maxActive integer 70
dbpool.default.maxIdle integer 20
dbpool.default.maxWaitMillis string 30 seconds
dbpool.default.minEvictableIdleTimeMillis string 15 seconds
dbpool.default.minIdle integer 0
dbpool.default.timeBetweenEvictionRunsMillis string 5 seconds
dbpool.ui.initialSize integer 5
dbpool.ui.maxActive integer 15
dbpool.ui.maxIdle integer 5
dbpool.ui.maxWaitMillis string 30 seconds
dbpool.ui.minEvictableIdleTimeMillis string 15 seconds
dbpool.ui.minIdle integer 0
dbpool.ui.timeBetweenEvictionRunsMillis string 5 seconds
graph.cache.period.minutes string 1
internal_perf_enable boolean false
internal_perf_server_id integer  
notify_thread_pool_size integer 4
quanal.collect string 00:01:00
supportReport.retention.minutes string 6 hours
thread_pool_size integer 8
ui.javascript.useClientSideStorage boolean false

  • graph.cache.period.minutes(1)

    Option-File Format graph.cache.period.minutes
      Permitted Values
    Type string
    Default 1

    Length of time that the graph images are cached in the service monitor.

  • notify_thread_pool_size(4)

    Option-File Format notify_thread_pool_size
      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)

    Option-File Format thread_pool_size
      Permitted Values
    Type integer
    Default 8

    Used to handle background jobs.

  • data_collection_interval(00:01:00)

    Option-File Format data_collection_interval
      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)

    Option-File Format internal_perf_enable
      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)

    Option-File Format internal_perf_server_id
      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)

    Option-File Format quanal.collect
      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)

    Option-File Format ui.javascript.useClientSideStorage
      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)

    Option-File Format supportReport.retention.minutes
      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)

    Option-File Format dbpool.ui.initialSize
      Permitted Values
    Type integer
    Default 5

  • dbpool.ui.maxActive(15)

    Option-File Format dbpool.ui.maxActive
      Permitted Values
    Type integer
    Default 15

  • dbpool.ui.minIdle(0)

    Option-File Format dbpool.ui.minIdle
      Permitted Values
    Type integer
    Default 0

  • dbpool.ui.maxIdle(5)

    Option-File Format dbpool.ui.maxIdle
      Permitted Values
    Type integer
    Default 5

  • dbpool.ui.maxWaitMillis(30 seconds)

    Option-File Format dbpool.ui.maxWaitMillis
      Permitted Values
    Type string
    Default 30 seconds

  • dbpool.ui.timeBetweenEvictionRunsMillis(5 seconds)

    Option-File Format dbpool.ui.timeBetweenEvictionRunsMillis
      Permitted Values
    Type string
    Default 5 seconds

  • dbpool.ui.minEvictableIdleTimeMillis(15 seconds)

    Option-File Format dbpool.ui.minEvictableIdleTimeMillis
      Permitted Values
    Type string
    Default 15 seconds

  • dbpool.default.initialSize(20)

    Option-File Format dbpool.default.initialSize
      Permitted Values
    Type integer
    Default 20

  • dbpool.default.maxActive(70)

    Option-File Format dbpool.default.maxActive
      Permitted Values
    Type integer
    Default 70

  • dbpool.default.minIdle(0)

    Option-File Format dbpool.default.minIdle
      Permitted Values
    Type integer
    Default 0

  • dbpool.default.maxIdle(5)

    Option-File Format dbpool.default.maxIdle
      Permitted Values
    Type integer
    Default 20

  • dbpool.default.maxWaitMillis(30 seconds)

    Option-File Format dbpool.default.maxWaitMillis
      Permitted Values
    Type string
    Default 30 seconds

  • dbpool.default.timeBetweenEvictionRunsMillis(5 seconds)

    Option-File Format dbpool.default.timeBetweenEvictionRunsMillis
      Permitted Values
    Type string
    Default 5 seconds

  • dbpool.default.minEvictableIdleTimeMillis(15 seconds)

    Option-File Format dbpool.default.minEvictableIdleTimeMillis
      Permitted Values
    Type string
    Default 15 seconds

Copyright © 2006, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices