prometheus 监控mysql数据库_mysql

prometheus 监控mysql数据库

本文通过prometheus 来监控mysql数据库状态，主要利用mysqld_exporter来实现mysql状态上报。
主机信息如下:

主机IP	用途
192.168.192.57	mysql数据库
192.168.192.58	prometheus 监控主机
192.168.192.58	grafana

prometheus 安装

prometheus安装很简单，只要下载安装包，本文以prometheus-2.33.0-rc.1.linux-amd64.tar.gz版本为例进行说明，只需要解压就可以直接使用。

配置prometheus.yml配置job监控mysql

# my global config
global:
  scrape_interval: 15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
  # scrape_timeout is set to the global default (10s).

# Alertmanager configuration
alerting:
  alertmanagers:
    - static_configs:
        - targets:
          # - alertmanager:9093

# Load rules once and periodically evaluate them according to the global 'evaluation_interval'.
rule_files:
  # - "first_rules.yml"
  # - "second_rules.yml"

# A scrape configuration containing exactly one endpoint to scrape:
# Here it's Prometheus itself.
scrape_configs:
  # The job name is added as a label `job=` to any timeseries scraped from this config.
  #监控主机node信息，依赖插件node_exporter
  - job_name: "192.168.192.57-node-info"
    static_configs:
    - targets: ['192.168.192.57:9100']
  #监控主机node信息，依赖插件mysql_exporter
   - job_name: 'mysql_monitor'
    static_configs:
    - targets: ['192.168.192.57:9104'

运行prometheus

直接执行命令 prometheus
启动成功后，用浏览器打开192.168.192.58:9090界面

安装配置mysqld-exporter

下载mysqld插件，更多插件见promethues插件相关地址。下载完成后解压mysqld_exporter-0.13.0.linux-amd64.tar.gz

配置mysql-exporter 在mysqld-exporter安装路径下，创建.my.cnf文件。内容如下:

[client]
user=mysql_monitor
password=Mysql@123

创建mysql 用户并授权

CREATE USER 'mysql_monitor'@'localhost' IDENTIFIED BY 'Mysql@123' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysql_monitor'@'localhost';
FLUSH PRIVILEGES;
EXIT

启动mysqld_exporter
执行 mysqld_exporter
查看mysql 监控信息
浏览器运行 http://192.168.192.57:9104/metrics，查看是否metrics数据输出，如果有输出内容监控就正常
grafana 安装配置安装

安装grafana-enterprise-8.3.3-1.x86_64.rpm，安装包下载地址，针对不同的系统版本安装命令如下：

配置

主要配置grafana data目录位置

[paths]
# Path to where grafana can store temp files, sessions, and the sqlite3 db (if that is used)
data = /opt/grafana/data

# Temporary files in `data` directory older than given duration will be removed
temp_data_lifetime = 240h

# Directory where grafana can store logs
logs = /opt/grafana/logs

database配置

[database]
# You can configure the database connection by specifying type, host, name, user and password
# as separate properties or as on string using the url properties.

# Either "mysql", "postgres" or "sqlite3", it's your choice
type = mysql
host = localhost:3306
name = grafana
user = root
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password ="""xxxxxxx"""

smpt配置

[smtp]
enabled = true
host = xxxxx:25
user = [email protected]
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password = xxxxx
;cert_file =
;key_file =
;skip_verify = false
;from_address = [email protected]
;from_name = Grafana
# EHLO identity in SMTP dialog (defaults to instance_name)
;ehlo_identity = dashboard.example.com
# SMTP startTLS policy (defaults to 'OpportunisticStartTLS')
;startTLS_policy = NoStartTLS

详细的配置说明，见官方文档
总配置文件如下：

##################### Grafana Configuration Example #####################
#
# Everything has defaults so you only need to uncomment things you want to
# change

# possible values : production, development
;app_mode = production

# instance name, defaults to HOSTNAME environment variable value or hostname if HOSTNAME var is empty
;instance_name = ${HOSTNAME}

#################################### Paths ####################################
[paths]
# Path to where grafana can store temp files, sessions, and the sqlite3 db (if that is used)
data = /opt/grafana/data

# Temporary files in `data` directory older than given duration will be removed
temp_data_lifetime = 240h

# Directory where grafana can store logs
logs = /opt/grafana/logs

# Directory where grafana will automatically scan and look for plugins
;plugins = /var/lib/grafana/plugins

# folder that contains provisioning config files that grafana will apply on startup and while running.
;provisioning = conf/provisioning

#################################### Server ####################################
[server]
# Protocol (http, https, h2, socket)
;protocol = http

# The ip address to bind to, empty will bind to all interfaces
;http_addr =

# The http port  to use
http_port = 3000

# The public facing domain name used to access grafana from a browser
domain = 192.168.192.58

# Redirect to correct domain if host header does not match domain
# Prevents DNS rebinding attacks
;enforce_domain = false

# The full public facing url you use in browser, used for redirects and emails
# If you use reverse proxy and sub path specify full url (with sub path)
;root_url = %(protocol)s://%(domain)s:%(http_port)s/

# Serve Grafana from subpath specified in `root_url` setting. By default it is set to `false` for compatibility reasons.
;serve_from_sub_path = false

# Log web requests
;router_logging = false

# the path relative working path
;static_root_path = public

# enable gzip
;enable_gzip = false

# https certs & key file
;cert_file =
;cert_key =

# Unix socket path
;socket =

# CDN Url
;cdn_url =

# Sets the maximum time using a duration format (5s/5m/5ms) before timing out read of an incoming request and closing idle connections.
# `0` means there is no timeout for reading the request.
;read_timeout = 0

#################################### Database ####################################
[database]
# You can configure the database connection by specifying type, host, name, user and password
# as separate properties or as on string using the url properties.

# Either "mysql", "postgres" or "sqlite3", it's your choice
type = mysql
host = localhost:3306
name = grafana
user = root
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password ="""xxxxxxx"""

# Use either URL or the previous fields to configure the database
# Example: mysql://user:secret@host:port/database
;url =

# For "postgres" only, either "disable", "require" or "verify-full"
;ssl_mode = disable

# Database drivers may support different transaction isolation levels.
# Currently, only "mysql" driver supports isolation levels.
# If the value is empty - driver's default isolation level is applied.
# For "mysql" use "READ-UNCOMMITTED", "READ-COMMITTED", "REPEATABLE-READ" or "SERIALIZABLE".
;isolation_level =

;ca_cert_path =
;client_key_path =
;client_cert_path =
;server_cert_name =

# For "sqlite3" only, path relative to data_path setting
;path = grafana.db

# Max idle conn setting default is 2
max_idle_conn = 5

# Max conn setting default is 0 (mean not set)
max_open_conn = 10

# Connection Max Lifetime default is 14400 (means 14400 seconds or 4 hours)
;conn_max_lifetime = 14400

# Set to true to log the sql calls and execution times.
;log_queries =

# For "sqlite3" only. cache mode setting used for connecting to the database. (private, shared)
;cache_mode = private

################################### Data sources #########################
[datasources]
# Upper limit of data sources that Grafana will return. This limit is a temporary configuration and it will be deprecated when pagination will be introduced on the list data sources API.
;datasource_limit = 5000

#################################### Cache server #############################
[remote_cache]
# Either "redis", "memcached" or "database" default is "database"
;type = database

# cache connectionstring options
# database: will use Grafana primary database.
# redis: config like redis server e.g. `addr=127.0.0.1:6379,pool_size=100,db=0,ssl=false`. Only addr is required. ssl may be 'true', 'false', or 'insecure'.
# memcache: 127.0.0.1:11211
;connstr =

#################################### Data proxy ###########################
[dataproxy]

# This enables data proxy logging, default is false
;logging = false

# How long the data proxy waits to read the headers of the response before timing out, default is 30 seconds.
# This setting also applies to core backend HTTP data sources where query requests use an HTTP client with timeout set.
;timeout = 30

# How long the data proxy waits to establish a TCP connection before timing out, default is 10 seconds.
;dialTimeout = 10

# How many seconds the data proxy waits before sending a keepalive probe request.
;keep_alive_seconds = 30

# How many seconds the data proxy waits for a successful TLS Handshake before timing out.
;tls_handshake_timeout_seconds = 10

# How many seconds the data proxy will wait for a server's first response headers after
# fully writing the request headers if the request has an "Expect: 100-continue"
# header. A value of 0 will result in the body being sent immediately, without
# waiting for the server to approve.
;expect_continue_timeout_seconds = 1

# Optionally limits the total number of connections per host, including connections in the dialing,
# active, and idle states. On limit violation, dials will block.
# A value of zero (0) means no limit.
;max_conns_per_host = 0

# The maximum number of idle connections that Grafana will keep alive.
;max_idle_connections = 100

# How many seconds the data proxy keeps an idle connection open before timing out.
;idle_conn_timeout_seconds = 90

# If enabled and user is not anonymous, data proxy will add X-Grafana-User header with username into the request, default is false.
;send_user_header = false

# Limit the amount of bytes that will be read/accepted from responses of outgoing HTTP requests.
;response_limit = 0

# Limits the number of rows that Grafana will process from SQL data sources.
;row_limit = 1000000

#################################### Analytics ####################################
[analytics]
# Server reporting, sends usage counters to stats.grafana.org every 24 hours.
# No ip addresses are being tracked, only simple counters to track
# running instances, dashboard and error counts. It is very helpful to us.
# Change this option to false to disable reporting.
;reporting_enabled = true

# The name of the distributor of the Grafana instance. Ex hosted-grafana, grafana-labs
;reporting_distributor = grafana-labs

# Set to false to disable all checks to https://grafana.net
# for new versions (grafana itself and plugins), check is used
# in some UI views to notify that grafana or plugin update exists
# This option does not cause any auto updates, nor send any information
# only a GET request to http://grafana.com to get latest versions
;check_for_updates = true

# Google Analytics universal tracking code, only enabled if you specify an id here
;google_analytics_ua_id =

# Google Tag Manager ID, only enabled if you specify an id here
;google_tag_manager_id =

#################################### Security ####################################
[security]
# disable creation of admin user on first start of grafana
;disable_initial_admin_creation = false

# default admin user, created on startup
;admin_user = admin

# default admin password, can be changed before first start of grafana,  or in profile settings
;admin_password = admin

# used for signing
;secret_key = SW2YcwTIb9zpOOhoPsMm

# current key provider used for envelope encryption, default to static value specified by secret_key
;encryption_provider = secretKey

# list of configured key providers, space separated (Enterprise only): e.g., awskms.v1 azurekv.v1
;available_encryption_providers =

# disable gravatar profile images
;disable_gravatar = false

# data source proxy whitelist (ip_or_domain:port separated by spaces)
;data_source_proxy_whitelist =

# disable protection against brute force login attempts
;disable_brute_force_login_protection = false

# set to true if you host Grafana behind HTTPS. default is false.
;cookie_secure = false

# set cookie SameSite attribute. defaults to `lax`. can be set to "lax", "strict", "none" and "disabled"
;cookie_samesite = lax

# set to true if you want to allow browsers to render Grafana in a , , <embed> or <object>. default is false.
;allow_embedding = false

# Set to true if you want to enable http strict transport security (HSTS) response header.
# This is only sent when HTTPS is enabled in this configuration.
# HSTS tells browsers that the site should only be accessed using HTTPS.
;strict_transport_security = false

# Sets how long a browser should cache HSTS. Only applied if strict_transport_security is enabled.
;strict_transport_security_max_age_seconds = 86400

# Set to true if to enable HSTS preloading option. Only applied if strict_transport_security is enabled.
;strict_transport_security_preload = false

# Set to true if to enable the HSTS includeSubDomains option. Only applied if strict_transport_security is enabled.
;strict_transport_security_subdomains = false

# Set to true to enable the X-Content-Type-Options response header.
# The X-Content-Type-Options response HTTP header is a marker used by the server to indicate that the MIME types advertised
# in the Content-Type headers should not be changed and be followed.
;x_content_type_options = true

# Set to true to enable the X-XSS-Protection header, which tells browsers to stop pages from loading
# when they detect reflected cross-site scripting (XSS) attacks.
;x_xss_protection = true

# Enable adding the Content-Security-Policy header to your requests.
# CSP allows to control resources the user agent is allowed to load and helps prevent XSS attacks.
;content_security_policy = false

# Set Content Security Policy template used when adding the Content-Security-Policy header to your requests.
# $NONCE in the template includes a random nonce.
# $ROOT_PATH is server.root_url without the protocol.
;content_security_policy_template = """script-src 'self' 'unsafe-eval' 'unsafe-inline' 'strict-dynamic' $NONCE;object-src 'none';font-src 'self';style-src 'self' 'unsafe-inline' blob:;img-src * data:;base-uri 'self';connect-src 'self' grafana.com ws://$ROOT_PATH wss://$ROOT_PATH;manifest-src 'self';media-src 'none';form-action 'self';"""

#################################### Snapshots ###########################
[snapshots]
# snapshot sharing options
;external_enabled = true
;external_snapshot_url = https://snapshots-origin.raintank.io
;external_snapshot_name = Publish to snapshot.raintank.io

# Set to true to enable this Grafana instance act as an external snapshot server and allow unauthenticated requests for
# creating and deleting snapshots.
;public_mode = false

# remove expired snapshot
;snapshot_remove_expired = true

#################################### Dashboards History ##################
[dashboards]
# Number dashboard versions to keep (per dashboard). Default: 20, Minimum: 1
;versions_to_keep = 20

# Minimum dashboard refresh interval. When set, this will restrict users to set the refresh interval of a dashboard lower than given interval. Per default this is 5 seconds.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;min_refresh_interval = 5s

# Path to the default home dashboard. If this value is empty, then Grafana uses StaticRootPath + "dashboards/home.json"
;default_home_dashboard_path =

#################################### Users ###############################
[users]
# disable user signup / registration
;allow_sign_up = true

# Allow non admin users to create organizations
;allow_org_create = true

# Set to true to automatically assign new users to the default organization (id 1)
;auto_assign_org = true

# Set this value to automatically add new users to the provided organization (if auto_assign_org above is set to true)
;auto_assign_org_id = 1

# Default role new users will be automatically assigned (if disabled above is set to true)
;auto_assign_org_role = Viewer

# Require email validation before sign up completes
;verify_email_enabled = false

# Background text for the user field on the login page
;login_hint = email or username
;password_hint = password

# Default UI theme ("dark" or "light")
;default_theme = dark

# Path to a custom home page. Users are only redirected to this if the default home dashboard is used. It should match a frontend route and contain a leading slash.
; home_page =

# External user management, these options affect the organization users view
;external_manage_link_url =
;external_manage_link_name =
;external_manage_info =

# Viewers can edit/inspect dashboard settings in the browser. But not save the dashboard.
;viewers_can_edit = false

# Editors can administrate dashboard, folders and teams they create
;editors_can_admin = false

# The duration in time a user invitation remains valid before expiring. This setting should be expressed as a duration. Examples: 6h (hours), 2d (days), 1w (week). Default is 24h (24 hours). The minimum supported duration is 15m (15 minutes).
;user_invite_max_lifetime_duration = 24h

# Enter a comma-separated list of users login to hide them in the Grafana UI. These users are shown to Grafana admins and themselves.
; hidden_users =

[auth]
# Login cookie name
;login_cookie_name = grafana_session

# The maximum lifetime (duration) an authenticated user can be inactive before being required to login at next visit. Default is 7 days (7d). This setting should be expressed as a duration, e.g. 5m (minutes), 6h (hours), 10d (days), 2w (weeks), 1M (month). The lifetime resets at each successful token rotation.
;login_maximum_inactive_lifetime_duration =

# The maximum lifetime (duration) an authenticated user can be logged in since login time before being required to login. Default is 30 days (30d). This setting should be expressed as a duration, e.g. 5m (minutes), 6h (hours), 10d (days), 2w (weeks), 1M (month).
;login_maximum_lifetime_duration =

# How often should auth tokens be rotated for authenticated users when being active. The default is each 10 minutes.
;token_rotation_interval_minutes = 10

# Set to true to disable (hide) the login form, useful if you use OAuth, defaults to false
;disable_login_form = false

# Set to true to disable the sign out link in the side menu. Useful if you use auth.proxy or auth.jwt, defaults to false
;disable_signout_menu = false

# URL to redirect the user to after sign out
;signout_redirect_url =

# Set to true to attempt login with OAuth automatically, skipping the login screen.
# This setting is ignored if multiple OAuth providers are configured.
;oauth_auto_login = false

# OAuth state max age cookie duration in seconds. Defaults to 600 seconds.
;oauth_state_cookie_max_age = 600

# limit of api_key seconds to live before expiration
;api_key_max_seconds_to_live = -1

# Set to true to enable SigV4 authentication option for HTTP-based datasources.
;sigv4_auth_enabled = false

#################################### Anonymous Auth ######################
[auth.anonymous]
# enable anonymous access
;enabled = false

# specify organization name that should be used for unauthenticated users
;org_name = Main Org.

# specify role for unauthenticated users
;org_role = Viewer

# mask the Grafana version number for unauthenticated users
;hide_version = false

#################################### GitHub Auth ##########################
[auth.github]
;enabled = false
;allow_sign_up = true
;client_id = some_id
;client_secret = some_secret
;scopes = user:email,read:org
;auth_url = https://github.com/login/oauth/authorize
;token_url = https://github.com/login/oauth/access_token
;api_url = https://api.github.com/user
;allowed_domains =
;team_ids =
;allowed_organizations =

#################################### GitLab Auth #########################
[auth.gitlab]
;enabled = false
;allow_sign_up = true
;client_id = some_id
;client_secret = some_secret
;scopes = api
;auth_url = https://gitlab.com/oauth/authorize
;token_url = https://gitlab.com/oauth/token
;api_url = https://gitlab.com/api/v4
;allowed_domains =
;allowed_groups =

#################################### Google Auth ##########################
[auth.google]
;enabled = false
;allow_sign_up = true
;client_id = some_client_id
;client_secret = some_client_secret
;scopes = https://www.googleapis.com/auth/userinfo.profile https://www.googleapis.com/auth/userinfo.email
;auth_url = https://accounts.google.com/o/oauth2/auth
;token_url = https://accounts.google.com/o/oauth2/token
;api_url = https://www.googleapis.com/oauth2/v1/userinfo
;allowed_domains =
;hosted_domain =

#################################### Grafana.com Auth ####################
[auth.grafana_com]
;enabled = false
;allow_sign_up = true
;client_id = some_id
;client_secret = some_secret
;scopes = user:email
;allowed_organizations =

#################################### Azure AD OAuth #######################
[auth.azuread]
;name = Azure AD
;enabled = false
;allow_sign_up = true
;client_id = some_client_id
;client_secret = some_client_secret
;scopes = openid email profile
;auth_url = https://login.microsoftonline.com/<tenant-id>/oauth2/v2.0/authorize
;token_url = https://login.microsoftonline.com/<tenant-id>/oauth2/v2.0/token
;allowed_domains =
;allowed_groups =

#################################### Okta OAuth #######################
[auth.okta]
;name = Okta
;enabled = false
;allow_sign_up = true
;client_id = some_id
;client_secret = some_secret
;scopes = openid profile email groups
;auth_url = https://<tenant-id>.okta.com/oauth2/v1/authorize
;token_url = https://<tenant-id>.okta.com/oauth2/v1/token
;api_url = https://<tenant-id>.okta.com/oauth2/v1/userinfo
;allowed_domains =
;allowed_groups =
;role_attribute_path =
;role_attribute_strict = false

#################################### Generic OAuth ##########################
[auth.generic_oauth]
;enabled = false
;name = OAuth
;allow_sign_up = true
;client_id = some_id
;client_secret = some_secret
;scopes = user:email,read:org
;empty_scopes = false
;email_attribute_name = email:primary
;email_attribute_path =
;login_attribute_path =
;name_attribute_path =
;id_token_attribute_name =
;auth_url = https://foo.bar/login/oauth/authorize
;token_url = https://foo.bar/login/oauth/access_token
;api_url = https://foo.bar/user
;teams_url =
;allowed_domains =
;team_ids =
;allowed_organizations =
;role_attribute_path =
;role_attribute_strict = false
;groups_attribute_path =
;team_ids_attribute_path =
;tls_skip_verify_insecure = false
;tls_client_cert =
;tls_client_key =
;tls_client_ca =
;use_pkce = false

#################################### Basic Auth ##########################
[auth.basic]
;enabled = true

#################################### Auth Proxy ##########################
[auth.proxy]
;enabled = false
;header_name = X-WEBAUTH-USER
;header_property = username
;auto_sign_up = true
;sync_ttl = 60
;whitelist = 192.168.1.1, 192.168.2.1
;headers = Email:X-User-Email, Name:X-User-Name
# Read the auth proxy docs for details on what the setting below enables
;enable_login_token = false

#################################### Auth JWT ##########################
[auth.jwt]
;enabled = true
;header_name = X-JWT-Assertion
;email_claim = sub
;username_claim = sub
;jwk_set_url = https://foo.bar/.well-known/jwks.json
;jwk_set_file = /path/to/jwks.json
;cache_ttl = 60m
;expected_claims = {"aud": ["foo", "bar"]}
;key_file = /path/to/key/file

#################################### Auth LDAP ##########################
[auth.ldap]
;enabled = false
;config_file = /etc/grafana/ldap.toml
;allow_sign_up = true

# LDAP background sync (Enterprise only)
# At 1 am every day
;sync_cron = "0 0 1 * * *"
;active_sync_enabled = true

#################################### AWS ###########################
[aws]
# Enter a comma-separated list of allowed AWS authentication providers.
# Options are: default (AWS SDK Default), keys (Access && secret key), credentials (Credentials field), ec2_iam_role (EC2 IAM Role)
; allowed_auth_providers = default,keys,credentials

# Allow AWS users to assume a role using temporary security credentials.
# If true, assume role will be enabled for all AWS authentication providers that are specified in aws_auth_providers
; assume_role_enabled = true

#################################### Azure ###############################
[azure]
# Azure cloud environment where Grafana is hosted
# Possible values are AzureCloud, AzureChinaCloud, AzureUSGovernment and AzureGermanCloud
# Default value is AzureCloud (i.e. public cloud)
;cloud = AzureCloud

# Specifies whether Grafana hosted in Azure service with Managed Identity configured (e.g. Azure Virtual Machines instance)
# If enabled, the managed identity can be used for authentication of Grafana in Azure services
# Disabled by default, needs to be explicitly enabled
;managed_identity_enabled = false

# Client ID to use for user-assigned managed identity
# Should be set for user-assigned identity and should be empty for system-assigned identity
;managed_identity_client_id =

#################################### SMTP / Emailing ##########################
[smtp]
enabled = true
host = xxxxx:25
user = xxxx@123.com
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password = xxxxx
;cert_file =
;key_file =
;skip_verify = false
;from_address = admin@grafana.localhost
;from_name = Grafana
# EHLO identity in SMTP dialog (defaults to instance_name)
;ehlo_identity = dashboard.example.com
# SMTP startTLS policy (defaults to 'OpportunisticStartTLS')
;startTLS_policy = NoStartTLS

[emails]
;welcome_email_on_sign_up = false
;templates_pattern = emails/*.html, emails/*.txt
;content_types = text/html

#################################### Logging ##########################
[log]
# Either "console", "file", "syslog". Default is console and  file
# Use space to separate multiple modes, e.g. "console file"
;mode = console file

# Either "debug", "info", "warn", "error", "critical", default is "info"
;level = info

# optional settings to set different levels for specific loggers. Ex filters = sqlstore:debug
;filters =

# For "console" mode only
[log.console]
;level =

# log line format, valid options are text, console and json
;format = console

# For "file" mode only
[log.file]
;level =

# log line format, valid options are text, console and json
;format = text

# This enables automated log rotate(switch of following options), default is true
;log_rotate = true

# Max line number of single file, default is 1000000
;max_lines = 1000000

# Max size shift of single file, default is 28 means 1 << 28, 256MB
;max_size_shift = 28

# Segment log daily, default is true
;daily_rotate = true

# Expired days of log file(delete after max days), default is 7
;max_days = 7

[log.syslog]
;level =

# log line format, valid options are text, console and json
;format = text

# Syslog network type and address. This can be udp, tcp, or unix. If left blank, the default unix endpoints will be used.
;network =
;address =

# Syslog facility. user, daemon and local0 through local7 are valid.
;facility =

# Syslog tag. By default, the process' argv[0] is used.
;tag =

[log.frontend]
# Should Sentry javascript agent be initialized
;enabled = false

# Sentry DSN if you want to send events to Sentry.
;sentry_dsn =

# Custom HTTP endpoint to send events captured by the Sentry agent to. Default will log the events to stdout.
;custom_endpoint = /log

# Rate of events to be reported between 0 (none) and 1 (all), float
;sample_rate = 1.0

# Requests per second limit enforced an extended period, for Grafana backend log ingestion endpoint (/log).
;log_endpoint_requests_per_second_limit = 3

# Max requests accepted per short interval of time for Grafana backend log ingestion endpoint (/log).
;log_endpoint_burst_limit = 15

#################################### Usage Quotas ########################
[quota]
; enabled = false

#### set quotas to -1 to make unlimited. ####
# limit number of users per Org.
; org_user = 10

# limit number of dashboards per Org.
; org_dashboard = 100

# limit number of data_sources per Org.
; org_data_source = 10

# limit number of api_keys per Org.
; org_api_key = 10

# limit number of alerts per Org.
;org_alert_rule = 100

# limit number of orgs a user can create.
; user_org = 10

# Global limit of users.
; global_user = -1

# global limit of orgs.
; global_org = -1

# global limit of dashboards
; global_dashboard = -1

# global limit of api_keys
; global_api_key = -1

# global limit on number of logged in users.
; global_session = -1

# global limit of alerts
;global_alert_rule = -1

#################################### Unified Alerting ####################
[unified_alerting]
#Enable the Unified Alerting sub-system and interface. When enabled we'll migrate all of your alert rules and notification channels to the new system. New alert rules will be created and your notification channels will be converted into an Alertmanager configuration. Previous data is preserved to enable backwards compatibility but new data is removed.```
;enabled = true

# Comma-separated list of organization IDs for which to disable unified alerting. Only supported if unified alerting is enabled.
;disabled_orgs =

# Specify the frequency of polling for admin config changes.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;admin_config_poll_interval = 60s

# Specify the frequency of polling for Alertmanager config changes.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;alertmanager_config_poll_interval = 60s

# Listen address/hostname and port to receive unified alerting messages for other Grafana instances. The port is used for both TCP and UDP. It is assumed other Grafana instances are also running on the same port. The default value is `0.0.0.0:9094`.
;ha_listen_address = "0.0.0.0:9094"

# Listen address/hostname and port to receive unified alerting messages for other Grafana instances. The port is used for both TCP and UDP. It is assumed other Grafana instances are also running on the same port. The default value is `0.0.0.0:9094`.
;ha_advertise_address = ""

# Comma-separated list of initial instances (in a format of host:port) that will form the HA cluster. Configuring this setting will enable High Availability mode for alerting.
;ha_peers = ""

# Time to wait for an instance to send a notification via the Alertmanager. In HA, each Grafana instance will
# be assigned a position (e.g. 0, 1). We then multiply this position with the timeout to indicate how long should
# each instance wait before sending the notification to take into account replication lag.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;ha_peer_timeout = "15s"

# The interval between sending gossip messages. By lowering this value (more frequent) gossip messages are propagated
# across cluster more quickly at the expense of increased bandwidth usage.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;ha_gossip_interval = "200ms"

# The interval between gossip full state syncs. Setting this interval lower (more frequent) will increase convergence speeds
# across larger clusters at the expense of increased bandwidth usage.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;ha_push_pull_interval = "60s"

# Enable or disable alerting rule execution. The alerting UI remains visible. This option has a legacy version in the `[alerting]` section that takes precedence.
;execute_alerts = true

# Alert evaluation timeout when fetching data from the datasource. This option has a legacy version in the `[alerting]` section that takes precedence.
# The timeout string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;evaluation_timeout = 30s

# Number of times we'll attempt to evaluate an alert rule before giving up on that evaluation. This option has a legacy version in the `[alerting]` section that takes precedence.
;max_attempts = 3

# Minimum interval to enforce between rule evaluations. Rules will be adjusted if they are less than this value  or if they are not multiple of the scheduler interval (10s). Higher values can help with resource management as we'll schedule fewer evaluations over time. This option has a legacy version in the `[alerting]` section that takes precedence.
# The interval string is a possibly signed sequence of decimal numbers, followed by a unit suffix (ms, s, m, h, d), e.g. 30s or 1m.
;min_interval = 10s

#################################### Alerting ############################
[alerting]
# Disable legacy alerting engine & UI features
;enabled = false

# Makes it possible to turn off alert execution but alerting UI is visible
;execute_alerts = true

# Default setting for new alert rules. Defaults to categorize error and timeouts as alerting. (alerting, keep_state)
;error_or_timeout = alerting

# Default setting for how Grafana handles nodata or null values in alerting. (alerting, no_data, keep_state, ok)
;nodata_or_nullvalues = no_data

# Alert notifications can include images, but rendering many images at the same time can overload the server
# This limit will protect the server from render overloading and make sure notifications are sent out quickly
;concurrent_render_limit = 5

# Default setting for alert calculation timeout. Default value is 30
;evaluation_timeout_seconds = 30

# Default setting for alert notification timeout. Default value is 30
;notification_timeout_seconds = 30

# Default setting for max attempts to sending alert notifications. Default value is 3
;max_attempts = 3

# Makes it possible to enforce a minimal interval between evaluations, to reduce load on the backend
;min_interval_seconds = 1

# Configures for how long alert annotations are stored. Default is 0, which keeps them forever.
# This setting should be expressed as a duration. Examples: 6h (hours), 10d (days), 2w (weeks), 1M (month).
;max_annotation_age =

# Configures max number of alert annotations that Grafana stores. Default value is 0, which keeps all alert annotations.
;max_annotations_to_keep =

#################################### Annotations #########################
[annotations]
# Configures the batch size for the annotation clean-up job. This setting is used for dashboard, API, and alert annotations.
;cleanupjob_batchsize = 100

[annotations.dashboard]
# Dashboard annotations means that annotations are associated with the dashboard they are created on.

# Configures how long dashboard annotations are stored. Default is 0, which keeps them forever.
# This setting should be expressed as a duration. Examples: 6h (hours), 10d (days), 2w (weeks), 1M (month).
;max_age =

# Configures max number of dashboard annotations that Grafana stores. Default value is 0, which keeps all dashboard annotations.
;max_annotations_to_keep =

[annotations.api]
# API annotations means that the annotations have been created using the API without any
# association with a dashboard.

# Configures how long Grafana stores API annotations. Default is 0, which keeps them forever.
# This setting should be expressed as a duration. Examples: 6h (hours), 10d (days), 2w (weeks), 1M (month).
;max_age =

# Configures max number of API annotations that Grafana keeps. Default value is 0, which keeps all API annotations.
;max_annotations_to_keep =

#################################### Explore #############################
[explore]
# Enable the Explore section
;enabled = true

#################################### Internal Grafana Metrics ##########################
# Metrics available at HTTP API Url /metrics
[metrics]
# Disable / Enable internal metrics
;enabled           = true
# Graphite Publish interval
;interval_seconds  = 10
# Disable total stats (stat_totals_*) metrics to be generated
;disable_total_stats = false

#If both are set, basic auth will be required for the metrics endpoint.
; basic_auth_username =
; basic_auth_password =

# Metrics environment info adds dimensions to the `grafana_environment_info` metric, which
# can expose more information about the Grafana instance.
[metrics.environment_info]
#exampleLabel1 = exampleValue1
#exampleLabel2 = exampleValue2

# Send internal metrics to Graphite
[metrics.graphite]
# Enable by setting the address setting (ex localhost:2003)
;address =
;prefix = prod.grafana.%(instance_name)s.

#################################### Grafana.com integration  ##########################
# Url used to import dashboards directly from Grafana.com
[grafana_com]
;url = https://grafana.com

#################################### Distributed tracing ############
[tracing.jaeger]
# Enable by setting the address sending traces to jaeger (ex localhost:6831)
;address = localhost:6831
# Tag that will always be included in when creating new spans. ex (tag1:value1,tag2:value2)
;always_included_tag = tag1:value1
# Type specifies the type of the sampler: const, probabilistic, rateLimiting, or remote
;sampler_type = const
# jaeger samplerconfig param
# for "const" sampler, 0 or 1 for always false/true respectively
# for "probabilistic" sampler, a probability between 0 and 1
# for "rateLimiting" sampler, the number of spans per second
# for "remote" sampler, param is the same as for "probabilistic"
# and indicates the initial sampling rate before the actual one
# is received from the mothership
;sampler_param = 1
# sampling_server_url is the URL of a sampling manager providing a sampling strategy.
;sampling_server_url =
# Whether or not to use Zipkin propagation (x-b3- HTTP headers).
;zipkin_propagation = false
# Setting this to true disables shared RPC spans.
# Not disabling is the most common setting when using Zipkin elsewhere in your infrastructure.
;disable_shared_zipkin_spans = false

#################################### External image storage ##########################
[external_image_storage]
# Used for uploading images to public servers so they can be included in slack/email messages.
# you can choose between (s3, webdav, gcs, azure_blob, local)
;provider =

[external_image_storage.s3]
;endpoint =
;path_style_access =
;bucket =
;region =
;path =
;access_key =
;secret_key =

[external_image_storage.webdav]
;url =
;public_url =
;username =
;password =

[external_image_storage.gcs]
;key_file =
;bucket =
;path =

[external_image_storage.azure_blob]
;account_name =
;account_key =
;container_name =

[external_image_storage.local]
# does not require any configuration

[rendering]
# Options to configure a remote HTTP image rendering service, e.g. using https://github.com/grafana/grafana-image-renderer.
# URL to a remote HTTP image renderer service, e.g. http://localhost:8081/render, will enable Grafana to render panels and dashboards to PNG-images using HTTP requests to an external service.
;server_url =
# If the remote HTTP image renderer service runs on a different server than the Grafana server you may have to configure this to a URL where Grafana is reachable, e.g. http://grafana.domain/.
;callback_url =
# Concurrent render request limit affects when the /render HTTP endpoint is used. Rendering many images at the same time can overload the server,
# which this setting can help protect against by only allowing a certain amount of concurrent requests.
;concurrent_render_request_limit = 30

[panels]
# If set to true Grafana will allow script tags in text panels. Not recommended as it enable XSS vulnerabilities.
;disable_sanitize_html = false

[plugins]
;enable_alpha = false
;app_tls_skip_verify_insecure = false
# Enter a comma-separated list of plugin identifiers to identify plugins to load even if they are unsigned. Plugins with modified signatures are never loaded.
;allow_loading_unsigned_plugins =
# Enable or disable installing / uninstalling / updating plugins directly from within Grafana.
;plugin_admin_enabled = false
;plugin_admin_external_manage_enabled = false
;plugin_catalog_url = https://grafana.com/grafana/plugins/
# Enter a comma-separated list of plugin identifiers to hide in the plugin catalog.
;plugin_catalog_hidden_plugins =

#################################### Grafana Live ##########################################
[live]
# max_connections to Grafana Live WebSocket endpoint per Grafana server instance. See Grafana Live docs
# if you are planning to make it higher than default 100 since this can require some OS and infrastructure
# tuning. 0 disables Live, -1 means unlimited connections.
;max_connections = 100

# allowed_origins is a comma-separated list of origins that can establish connection with Grafana Live.
# If not set then origin will be matched over root_url. Supports wildcard symbol "*".
;allowed_origins =

# engine defines an HA (high availability) engine to use for Grafana Live. By default no engine used - in
# this case Live features work only on a single Grafana server. Available options: "redis".
# Setting ha_engine is an EXPERIMENTAL feature.
;ha_engine =

# ha_engine_address sets a connection address for Live HA engine. Depending on engine type address format can differ.
# For now we only support Redis connection address in "host:port" format.
# This option is EXPERIMENTAL.
;ha_engine_address = "127.0.0.1:6379"

#################################### Grafana Image Renderer Plugin ##########################
[plugin.grafana-image-renderer]
# Instruct headless browser instance to use a default timezone when not provided by Grafana, e.g. when rendering panel image of alert.
# See ICU’s metaZones.txt (https://cs.chromium.org/chromium/src/third_party/icu/source/data/misc/metaZones.txt) for a list of supported
# timezone IDs. Fallbacks to TZ environment variable if not set.
;rendering_timezone =

# Instruct headless browser instance to use a default language when not provided by Grafana, e.g. when rendering panel image of alert.
# Please refer to the HTTP header Accept-Language to understand how to format this value, e.g. 'fr-CH, fr;q=0.9, en;q=0.8, de;q=0.7, *;q=0.5'.
;rendering_language =

# Instruct headless browser instance to use a default device scale factor when not provided by Grafana, e.g. when rendering panel image of alert.
# Default is 1. Using a higher value will produce more detailed images (higher DPI), but will require more disk space to store an image.
;rendering_viewport_device_scale_factor =

# Instruct headless browser instance whether to ignore HTTPS errors during navigation. Per default HTTPS errors are not ignored. Due to
# the security risk it's not recommended to ignore HTTPS errors.
;rendering_ignore_https_errors =

# Instruct headless browser instance whether to capture and log verbose information when rendering an image. Default is false and will
# only capture and log error messages. When enabled, debug messages are captured and logged as well.
# For the verbose information to be included in the Grafana server log you have to adjust the rendering log level to debug, configure
# [log].filter = rendering:debug.
;rendering_verbose_logging =

# Instruct headless browser instance whether to output its debug and error messages into running process of remote rendering service.
# Default is false. This can be useful to enable (true) when troubleshooting.
;rendering_dumpio =

# Additional arguments to pass to the headless browser instance. Default is --no-sandbox. The list of Chromium flags can be found
# here (https://peter.sh/experiments/chromium-command-line-switches/). Multiple arguments is separated with comma-character.
;rendering_args =

# You can configure the plugin to use a different browser binary instead of the pre-packaged version of Chromium.
# Please note that this is not recommended, since you may encounter problems if the installed version of Chrome/Chromium is not
# compatible with the plugin.
;rendering_chrome_bin =

# Instruct how headless browser instances are created. Default is 'default' and will create a new browser instance on each request.
# Mode 'clustered' will make sure that only a maximum of browsers/incognito pages can execute concurrently.
# Mode 'reusable' will have one browser instance and will create a new incognito page on each request.
;rendering_mode =

# When rendering_mode = clustered, you can instruct how many browsers or incognito pages can execute concurrently. Default is 'browser'
# and will cluster using browser instances.
# Mode 'context' will cluster using incognito pages.
;rendering_clustering_mode =
# When rendering_mode = clustered, you can define the maximum number of browser instances/incognito pages that can execute concurrently. Default is '5'.
;rendering_clustering_max_concurrency =
# When rendering_mode = clustered, you can specify the duration a rendering request can take before it will time out. Default is `30` seconds.
;rendering_clustering_timeout =

# Limit the maximum viewport width, height and device scale factor that can be requested.
;rendering_viewport_max_width =
;rendering_viewport_max_height =
;rendering_viewport_max_device_scale_factor =

# Change the listening host and port of the gRPC server. Default host is 127.0.0.1 and default port is 0 and will automatically assign
# a port not in use.
;grpc_host =
;grpc_port =

[enterprise]
# Path to a valid Grafana Enterprise license.jwt file
;license_path =

[feature_toggles]
# enable features, separated by spaces
;enable =

[date_formats]
# For information on what formatting patterns that are supported https://momentjs.com/docs/#/displaying/

# Default system date format used in time range picker and other places where full time is displayed
;full_date = YYYY-MM-DD HH:mm:ss

# Used by graph and other places where we only show small intervals
;interval_second = HH:mm:ss
;interval_minute = HH:mm
;interval_hour = MM/DD HH:mm
;interval_day = MM/DD
;interval_month = YYYY-MM
;interval_year = YYYY

# Experimental feature
;use_browser_locale = false

# Default timezone for user preferences. Options are 'browser' for the browser local timezone or a timezone name from IANA Time Zone database, e.g. 'UTC' or 'Europe/Amsterdam' etc.
;default_timezone = browser

[expressions]
# Enable or disable the expressions functionality.
;enabled = true

[geomap]
# Set the JSON configuration for the default basemap
;default_baselayer_config = `{
;  "type": "xyz",
;  "config": {
;    "attribution": "Open street map",
;    "url": "https://tile.openstreetmap.org/{z}/{x}/{y}.png"
;  }
;}`

# Enable or disable loading other base map layers
;enable_custom_baselayers = true


# Enterprise only
[white_labeling]
# Set to your company name to override application title
;app_title =

# Set to main title on the login page
;login_title =

# Set to login subtitle
;login_subtitle =

# Set to complete url to override login logo
;login_logo =

# Set to complete css background expression to override login background
# example: login_background = url(http://www.kaotop.com/file/tupian/20220518/starfield-1920x1080.jpg)
;login_background =

# Set to complete css background expression to override login box background
;login_box_background =

# Set to complete url to override menu logo
;menu_logo =

# Set to complete url to override fav icon (icon shown in browser tab)
;fav_icon =

# Set to complete url to override apple/ios icon
;apple_touch_icon =

# Set to complete url to override loading logo
;loading_logo =

# Below is an example for how to replace the default footer & help links with 2 custom links
;footer_links = support guides
;footer_links_support_text = Support
;footer_links_support_url = http://your.support.site
;footer_links_guides_text = Guides
;footer_links_guides_url = http://your.guides.site

[usage_insights.export]
# Enable the usage insights export feature
; enabled = false
# Storage type
; storage = loki

[usage_insights.export.storage.loki]
# Set the communication protocol to use with Loki (can be grpc or http)
; type = grpc
# Set the address for writing logs to Loki (format must be host:port)
; url = localhost:9095
# Defaults to true. If true, it establishes a secure connection to Loki
; tls = true

[reporting]
# Set timeout for each panel rendering request
;rendering_timeout = 10s
# Set maximum number of concurrent calls to the rendering service
;concurrent_render_limit = 4
# Set the scale factor for rendering images. 2 is enough for monitor resolutions
# 4 would be better for printed material. Setting a higher value affects performance and memory
;image_scale_factor = 2
# Set the maximum file size in megabytes for the CSV attachments
; max_attachment_size_mb = 10
# Path to the directory containing fonts
;fonts_path =
# Name of the TrueType font file with Regular style
;font_regular = DejaVuSansCondensed.ttf
# Name of the TrueType font file with Bold style
;font_bold = DejaVuSansCondensed-Bold.ttf
# Name of the TrueType font file with Italic style
;font_italic = DejaVuSansCondensed-Oblique.ttf

[analytics.summaries]
# Set interval for writing dashboard usage stats buffer to database
;buffer_write_interval = 30s
# Set timeout for writing dashboard usage stats buffer to database
;buffer_write_timeout = 3s
# Set interval for trying to rollup per dashboard usage summary
# only rolled up at most once per day
;rollup_interval = 4h
# Set timeout for trying to rollup per dashboard usage summary
;rollup_timeout = 60s

[analytics.views]
# Set age for recent active users
;recent_users_age = 10m

[auditing]
# Enable the auditing feature
; enabled = false
# List of enabled loggers
;loggers = file
# Keep dashboard content in the logs (request or response fields); this can significantly increase the size of your logs.
;log_dashboard_content = false

[auditing.logs.file]
# Path to logs folder
;path = data/log
# Maximum log files to keep
;max_files = 5
# Max size in megabytes per log file
;max_file_size_mb = 256

[auditing.logs.loki]
# Set the communication protocol to use with Loki (can be grpc or http)
;type = grpc
# Set the address for writing logs to Loki (format must be host:port)
;url = localhost:9095
# Defaults to true. If true, it establishes a secure connection to Loki
;tls = true

#################################### SAML Auth ###########################
[auth.saml]
# Defaults to false. If true, the feature is enabled.
;enabled = false
# Enable SAML single logout
;single_logout = false
# Base64-encoded public X.509 certificate. Used to sign requests to the IdP
;certificate =
# Path to the public X.509 certificate. Used to sign requests to the IdP
;certificate_path =
# Base64-encoded private key. Used to decrypt assertions from the IdP
;private_key =
;# Path to the private key. Used to decrypt assertions from the IdP
;private_key_path =
# Signature algorithm using for signing requests to the IdP. Supported values are rsa-sha1, rsa-sha256, rsa-sha512.
# If non-empty, authentication requests will be signed. Default is empty (requests not signed).
;signature_algorithm =
# Base64-encoded IdP SAML metadata XML. Used to verify and obtain binding locations from the IdP
;idp_metadata =
# Path to the SAML metadata XML. Used to verify and obtain binding locations from the IdP
;idp_metadata_path =
# URL to fetch SAML IdP metadata. Used to verify and obtain binding locations from the IdP
;idp_metadata_url =
# Duration, since the IdP issued a response and the SP is allowed to process it. Defaults to 90 seconds.
;max_issue_delay = 90s
# Duration, for how long the SP's metadata should be valid. Defaults to 48 hours.
;metadata_valid_duration = 48h
# Allow IdP-initiated SSO
;allow_idp_initiated = false
# Relay state for IdP-initiated SSO. Should match relay state configured in IdP
;relay_state =
# Friendly name or name of the attribute within the SAML assertion to use as the user's name
;assertion_attribute_name = displayName
# Friendly name or name of the attribute within the SAML assertion to use as the user's login handle
;assertion_attribute_login = mail
# Friendly name or name of the attribute within the SAML assertion to use as the user's email
;assertion_attribute_email = mail
# Friendly name or name of the attribute within the SAML assertion to use as the user's groups
;assertion_attribute_groups = group
# Friendly name or name of the attribute within the SAML assertion to use as the user's roles
;assertion_attribute_role = role
# Friendly name or name of the attribute within the SAML assertion to use as the user's organization Id
;assertion_attribute_org = organizatio
# List of comma- or space-separated organizations. User should be a member of at least one organization to log in.
;allowed_organizations = Engineering, Sales
# List of comma- or space-separated Organization:OrgId mappings
;org_mapping = Engineering:2, Sales:3
# List of comma- or space-separated roles which will be mapped into the Editor role
;role_values_editor = editor, developer
# List of comma- or space-separated roles which will be mapped into the Admin role
;role_values_admin = admin
# List of comma- or space-separated roles which will be mapped into the Grafana Admin (Super Admin) role
;role_values_grafana_admin = superadmin

[keystore.vault]
# Location of the Vault server
;url =
# Vault's namespace if using Vault with multi-tenancy
;namespace =
# Method for authenticating towards Vault. Vault is inactive if this option is not set
# Possible values: token
;auth_method =
# Secret token to connect to Vault when auth_method is token
;token =
# Time between checking if there are any secrets which needs to be renewed.
;lease_renewal_interval = 5m
# Time until expiration for tokens which are renewed. Should have a value higher the lease_renewal_interval
;lease_renewal_expires_within = 15m
# New duration for renewed tokens. Vault may be configured to ignore this value and impose a stricter limit.
;lease_renewal_increment = 1h

[auth.security]
# Protected roles defines a set of user roles for which Grafana will not try to map users that have previously logged in
# with one solution with another. Configuration values are separated by space,
# possible values are = all editors viewers org_admins server_admins
;protected_roles =

[security.egress]
# Allow and deny lists can be used to control what hosts can be accessed based on what a user can configure through the ui.
# This includes:
# - datasource requests
# - alerting channels
# a list of hostnames or IP adresses separated by spaces for which outgoing requests will be blocked
;host_deny_list =
# a list of hostnames or IP adresses separated by spaces for which requests will be allowed, all other requests will be blocked
;host_allow_list =

# a list of headers that will be stripped from outgoing datasource and alerting requests
;header_drop_list =
# a list of cookies that will be stripped from outgoing datasource requests
;cookie_drop_list =

[security.encryption]
# Encryption algorithm used to encrypt secrets stored into the database and cookies,
# possible values are aes-cfb and aes-gcm.
;algorithm = aes-cfb

# Example of AWS Key Management Service provider setup
[security.encryption.awskms.v1]
# Reference to KMS key - either  key ID, key ARN, alias name or ARN.
# Alias needs to be prefixed with "alias".
# To specify a KMS key in a different AWS account, use the ARN or alias.
# Examples of each type:
# Key ID:     1234abcd-12ab-34cd-56ef-1234567890ab
# Key ARN:    arn:aws:kms:us-east-2:111122223333:key/1234abcd-12ab-34cd-56ef-1234567890ab
# Alias name: alias/ExampleAlias
# Alias ARN:  arn:aws:kms:us-east-2:111122223333:alias/ExampleAlias
;key_id =
# AWS access key ID
;access_key_id =
# AWS secret access key
;secret_access_key =
# AWS session token, optional
;token =
# AWS region (e.g., eu-north-1)
;region =

# Example of Azure Key Vault provider setup
[security.encryption.azurekv.v1]
# Azure Application directory ID (tenant)
;tenant_id =
# Azure Application application ID (client)
;client_id =
# Azure Application client secret
;client_secret =
# Azure Key Vault key name
;key_id =
# Azure Key Vault uri
;vault_uri =

# Caching is disabled on all data source by default
# Visit the data source settings to enable caching
[caching]
# Setting 'enabled' to true enables query caching for data sources with configured caching.
# To disable caching for a specific data source, refer to the data source’s configuration page.
; enabled = true
# The caching backend to use when storing cached queries. Options: redis, memory
; backend = "memory"
# The default TTL (time to live) if no other TTL is available.
; ttl = 5m
# This value limits the size of a single cache value. If a cache value (or query result) is submitted that exceeds this size, then it will be rejected.
# To disable this limit, set this value to zero.
; max_value_mb = 10

[caching.encryption]
# Setting 'enabled' to true enables encryption of the values in the cache.
;enabled = true
# The key used for the encryption of the values in the cache. If it is not specified and encryption is enabled, the key will be randomly
# generated on startup. This must be specified to allow the encrypted cache to persist between Grafana restarts. If not specified, the cache
# will be cleared upon restarts.
;encryption_key = "oH0aaomqRDyd7gkvZTKwsxVwlvFpyhko"

[caching.memory]
# When storing cache data, how often a background process will clean up stale data from the in-memory cache
; gc_interval = 1m
# The maximum size of the in-memory cache in megabytes. Once this size is reached, new cache items will be rejected. For more flexible control over cache eviction policies and size, please use the Redis or Memcached backend
# To disable the maximum, set this value to 0. WARNING: Disabling the maximum is not recommended in production environments.
; max_size_mb = 25

[caching.redis]
# url should be a redis URL
; url = "redis://localhost:6379"
# prefix redis keys with this string. Example: 'grafana:<key>'. This value can be left empty and no prefix will be set.
; prefix = "grafana"
# a comma-separated list of Redis cluster members in host:port format
# if cluster is specified, the value for url is ignored
; cluster =

[caching.memcached]
# A space-separated list of memcached servers
; memcached_servers = "localhost:11211"

</code></pre> 
启动grafana 
<pre><code >systemctl restart grafana-server
</code></pre> 
登录grafana ui http://192.168.192.58:3000/,默认用户密码都为admin,登录成功后如下：<br /> 配置prometheus 数据源<br /> 导入mysql dashboards<br /> dashboardsGrafana官网地址<br /> <br /> 导入步骤<br /> <br /> 导入成功后，就可以浏览<br />					
										


					<div class="entry-copyright">
						<p>欢迎分享，转载请注明来源：<a href="https://www.outofmemory.cn" title="内存溢出">内存溢出</a></p><p>原文地址: <a href="https://www.outofmemory.cn/sjk/991818.html" title="prometheus 监控mysql数据库">https://www.outofmemory.cn/sjk/991818.html</a></p>
					</div>
				</div>
								<div class="entry-tag">
										<a href="/tag/113.html" rel="tag">mysql</a>
										<a href="/tag/104.html" rel="tag">数据库</a>
										<a href="/tag/21.html" rel="tag">linux</a>
									</div>
								<div class="entry-action">
					<a id="thread-like" class="btn-zan" href="javascript:;" tid="991818">
						<i class="wpcom-icon wi">
							<svg aria-hidden="true">
								<use xlink:href="#wi-thumb-up-fill"></use>
							</svg>
						</i> 赞
						<span class="entry-action-num">(0)</span>
					</a>
					<div class="btn-dashang">
						<i class="wpcom-icon wi">
							<svg aria-hidden="true">
								<use xlink:href="#wi-cny-circle-fill"></use>
							</svg></i> 打赏
						<span class="dashang-img dashang-img2">
							<span>
								<img src="/view/img/theme/weipay.png" alt="微信扫一扫" /> 微信扫一扫
							</span>
							<span>
								<img src="/view/img/theme/alipay.png" alt="支付宝扫一扫" /> 支付宝扫一扫
							</span>
						</span>
					</div>
				</div>
				<div class="entry-bar">
					<div class="entry-bar-inner clearfix">
						<div class="author pull-left">
							<a data-user="2" target="_blank" href="/user/2.html" class="avatar j-user-card">
								<img alt="code" src="/view/img/avatar.png" class="avatar avatar-60 photo" height="60" width="60" />
								<span class="author-name">code</span>
								<span class="user-group">管理员组</span>
							</a>
						</div>
						<div class="info pull-right">
							<div class="info-item meta">
								<a class="meta-item j-heart" id="favorites" rel="nofollow" tid="991818" href="javascript:void(0);" title="自己的内容还要收藏吗？" aria-label="自己的内容还要收藏吗？">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-star"></use></svg>
									</i>
									<span class="data">0</span>
								</a>
								<a class="meta-item" href="#comments">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-comment"></use></svg>
									</i>
									<span class="data">0</span>
								</a>
							</div>
							<div class="info-item share">
								<a class="meta-item mobile j-mobile-share22" a href="javascript:;" data-event="poster-popover">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-share"></use></svg>
									</i>
									生成海报
								</a>
								<a class="meta-item wechat" data-share="wechat" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-wechat"></use></svg>
									</i>
								</a>
								<a class="meta-item weibo" data-share="weibo" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-weibo"></use></svg>
									</i>
								</a>
								<a class="meta-item qq" data-share="qq" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-qq"></use></svg>
									</i>
								</a>
								<a class="meta-item qzone" data-share="qzone" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-qzone"></use></svg>
									</i>
								</a>
							</div>
							<div class="info-item act">
								<a href="javascript:;" id="j-reading">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-article"></use></svg>
									</i>
								</a>
							</div>
						</div>
					</div>
				</div>
			</div>
			<!--尾部广告-->
            <div class="wrap">
            	<script src="https://v.2lian.com/static/s/tubiao.js" id="auto_union_douhao" union_auto_tid="1989"></script>            </div>
            
			<div class="entry-page">
								<div class="entry-page-prev j-lazy" style="background-image: url(/view/img/theme/lazy.png);" data-original="/aiimages/mysql8.0%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B%E4%B8%8E%E9%85%8D%E7%BD%AE%EF%BC%88%E6%9C%80%E8%AF%A6%E7%BB%86%EF%BC%89%E6%93%8D%E4%BD%9C%E7%AE%80%E5%8D%95.png">
					<a href="/sjk/991817.html" title="mysql8.0安装教程与配置（最详细） *** 作简单" rel="prev">
						<span>mysql8.0安装教程与配置（最详细） *** 作简单</span>
					</a>
					<div class="entry-page-info">
         				<span class="pull-left">
							<i class="wpcom-icon wi">
								<svg aria-hidden="true"><use xlink:href="#wi-arrow-left-double"></use></svg>
							</i> 上一篇
						</span>
						<span class="pull-right">2022-05-21</span>
					</div>
				</div>
												<div class="entry-page-next j-lazy" style="background-image: url(/view/img/theme/lazy.png);" data-original="/aiimages/Java%E9%A1%B9%E7%9B%AE%3A%E9%85%92%E5%BA%97%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F%28java%2BSSM%2BMaven%2BLayUI%2Bmysql%29.png">
					<a href="/sjk/991819.html" title="Java项目:酒店管理系统(java+SSM+Maven+LayUI+mysql)" rel="next">
						<span>Java项目:酒店管理系统(java+SSM+Maven+LayUI+mysql)</span>
					</a>
					<div class="entry-page-info">
         				<span class="pull-right">
							下一篇 <i class="wpcom-icon wi">
           						<svg aria-hidden="true"><use xlink:href="#wi-arrow-right-double"></use></svg>
							</i>
						</span>
						<span class="pull-left">2022-05-21</span>
					</div>
				</div>
							</div>

			
			<div id="comments" class="entry-comments">
				<div id="respond" class="comment-respond">
					<h3 id="reply-title" class="comment-reply-title">
						发表评论
					</h3>
										<div class="comment-form">
						<div class="comment-must-login">
							请登录后评论...
						</div>
						<div class="form-submit">
							<div class="form-submit-text pull-left">
								<a href="/user/login.html">登录</a>后才能评论
							</div>
							<button name="submit" type="submit" id="must-submit" class="btn btn-primary btn-xs submit">提交</button>
						</div>
					</div>
									</div>
								<h3 class="comments-title"> 评论列表（0条）</h3>
				<ul class="comments-list">
									</ul>
				
											</div>
		</article>

	</main>

	<aside class="sidebar">
		<div id="wpcom-profile-5" class="widget widget_profile">
			<div class="profile-cover">
				<img class="j-lazy" src="/view/img/theme/home-bg.jpg" alt="code" />
			</div>
			<div class="avatar-wrap">
				<a target="_blank" href="/user/2.html" class="avatar-link">
					<img alt="code" src="/view/img/avatar.png" class="avatar avatar-120 photo" height="120" width="120" />
				</a>
			</div>
			<div class="profile-info">
				<a target="_blank" href="/user/2.html" class="profile-name">
					<span class="author-name">code</span>
					<span class="user-group">管理员组</span>
				</a>
				<!--<p class="author-description">Enjoy coding, enjoy life!</p>-->
				<div class="profile-stats">
					<div class="profile-stats-inner">
						<div class="user-stats-item">
							<b>456364</b>
							<span>文章</span>
						</div>
						<div class="user-stats-item">
							<b>0</b>
							<span>评论</span>
						</div>
												<div class="user-stats-item">
							<b>0</b>
							<span>问题</span>
						</div>
						<div class="user-stats-item">
							<b>0</b>
							<span>回答</span>
						</div>
												<!--<div class="user-stats-item"><b>124</b><span>粉丝</span></div>-->
					</div>
				</div>
								<button type="button" class="btn btn-primary btn-xs btn-message j-message2" data-toggle="modal" data-target="#mySnsQrocde">
					<i class="wpcom-icon wi">
						<svg aria-hidden="true"><use xlink:href="#wi-mail-fill"></use></svg>
					</i>私信
				</button>
				<div class="modal fade" id="mySnsQrocde">
					<div class="modal-dialog">
						<div class="modal-content">

							<!-- 模态框头部 -->
							<!--<div class="modal-header">
								<h4 class="modal-title">扫码联系我</h4>
								<button type="button" class="close" data-dismiss="modal">&times;</button>
							</div>-->

							<!-- 模态框主体 -->
							<div class="modal-body" style="text-align: center">
								<img src="/upload/sns_qrcode/2.png" style="width: 300px">
							</div>

						</div>
					</div>
				</div>
			</div>

						<div class="profile-posts">
				<h3 class="widget-title"><span>最近文章</span></h3>
				<ul>
										<li>
						<a href="/zz/13470075.html" title="网页显示不正常">
							网页显示不正常						</a>
					</li>
										<li>
						<a href="/zz/13467426.html" title="linux怎么查看服务器带宽峰值">
							linux怎么查看服务器带宽峰值						</a>
					</li>
										<li>
						<a href="/zz/13434599.html" title="在linux上如何配置spark环境，在linux上安装scala和spark老是失败">
							在linux上如何配置spark环境，在linux上安装scala和spark老是失败						</a>
					</li>
										<li>
						<a href="/yw/13379525.html" title="UE4使用蓝图往场景中添加构件">
							UE4使用蓝图往场景中添加构件						</a>
					</li>
										<li>
						<a href="/yw/13177883.html" title="手机中毒有哪些表现？怎么杀毒呀">
							手机中毒有哪些表现？怎么杀毒呀						</a>
					</li>
									</ul>
			</div>
					</div>
				<div id="wpcom-post-thumb-5" class="widget widget_post_thumb">
			<h3 class="widget-title"><span>相关文章</span></h3>
						<ul>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585953.html" title="smdms超市订单管理系统之登录功能">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="smdms超市订单管理系统之登录功能"  data-original="/aiimages/smdms%E8%B6%85%E5%B8%82%E8%AE%A2%E5%8D%95%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F%E4%B9%8B%E7%99%BB%E5%BD%95%E5%8A%9F%E8%83%BD.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585953.html" title="smdms超市订单管理系统之登录功能">
								smdms超市订单管理系统之登录功能							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585921.html" title="showDoc的基本使用方法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="showDoc的基本使用方法"  data-original="/aiimages/showDoc%E7%9A%84%E5%9F%BA%E6%9C%AC%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585921.html" title="showDoc的基本使用方法">
								showDoc的基本使用方法							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585823.html" title="GP数据库 常用SQL语句">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="GP数据库 常用SQL语句"  data-original="/aiimages/GP%E6%95%B0%E6%8D%AE%E5%BA%93+%E5%B8%B8%E7%94%A8SQL%E8%AF%AD%E5%8F%A5.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585823.html" title="GP数据库 常用SQL语句">
								GP数据库 常用SQL语句							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585769.html" title="FMDB用法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="FMDB用法"  data-original="/aiimages/FMDB%E7%94%A8%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585769.html" title="FMDB用法">
								FMDB用法							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585743.html" title="MSDB数据库置疑的解决方法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="MSDB数据库置疑的解决方法"  data-original="/aiimages/MSDB%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BD%AE%E7%96%91%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585743.html" title="MSDB数据库置疑的解决方法">
								MSDB数据库置疑的解决方法							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585612.html" title="EJB 总结学习（1）">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="EJB 总结学习（1）"  data-original="/aiimages/EJB+%E6%80%BB%E7%BB%93%E5%AD%A6%E4%B9%A0%EF%BC%881%EF%BC%89.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585612.html" title="EJB 总结学习（1）">
								EJB 总结学习（1）							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585605.html" title="vss使用详解">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="vss使用详解"  data-original="/aiimages/vss%E4%BD%BF%E7%94%A8%E8%AF%A6%E8%A7%A3.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585605.html" title="vss使用详解">
								vss使用详解							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585444.html" title="Srvctl命令具体解释（10g）">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="Srvctl命令具体解释（10g）"  data-original="/aiimages/Srvctl%E5%91%BD%E4%BB%A4%E5%85%B7%E4%BD%93%E8%A7%A3%E9%87%8A%EF%BC%8810g%EF%BC%89.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585444.html" title="Srvctl命令具体解释（10g）">
								Srvctl命令具体解释（10g）							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/585434.html" title="DRDS 概述">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="DRDS 概述"  data-original="/aiimages/DRDS+%E6%A6%82%E8%BF%B0.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/585434.html" title="DRDS 概述">
								DRDS 概述							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/584899.html" title="Qt初学者的开发经历">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="Qt初学者的开发经历"  data-original="/aiimages/Qt%E5%88%9D%E5%AD%A6%E8%80%85%E7%9A%84%E5%BC%80%E5%8F%91%E7%BB%8F%E5%8E%86.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/584899.html" title="Qt初学者的开发经历">
								Qt初学者的开发经历							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/584588.html" title="数据库知识点">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="数据库知识点"  data-original="/aiimages/%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9F%A5%E8%AF%86%E7%82%B9.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/584588.html" title="数据库知识点">
								数据库知识点							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/584519.html" title="sqli-labs做题记录">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="sqli-labs做题记录"  data-original="/aiimages/sqli-labs%E5%81%9A%E9%A2%98%E8%AE%B0%E5%BD%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/584519.html" title="sqli-labs做题记录">
								sqli-labs做题记录							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/579893.html" title="python中sqlite的基本调用和数据库类的封装案例">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="python中sqlite的基本调用和数据库类的封装案例"  data-original="/aiimages/python%E4%B8%ADsqlite%E7%9A%84%E5%9F%BA%E6%9C%AC%E8%B0%83%E7%94%A8%E5%92%8C%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B1%BB%E7%9A%84%E5%B0%81%E8%A3%85%E6%A1%88%E4%BE%8B.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/579893.html" title="python中sqlite的基本调用和数据库类的封装案例">
								python中sqlite的基本调用和数据库类的封装案例							</a>
						</p>
						<p class="item-date">2022-4-11</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/577675.html" title="ClickHouse简介">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="ClickHouse简介"  data-original="/aiimages/ClickHouse%E7%AE%80%E4%BB%8B.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/577675.html" title="ClickHouse简介">
								ClickHouse简介							</a>
						</p>
						<p class="item-date">2022-4-11</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zz/577173.html" title="MySQL和SQLite有什么区别?MySQL和SQLite比较">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="MySQL和SQLite有什么区别?MySQL和SQLite比较"  data-original="/aiimages/MySQL%E5%92%8CSQLite%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB%3FMySQL%E5%92%8CSQLite%E6%AF%94%E8%BE%83.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zz/577173.html" title="MySQL和SQLite有什么区别?MySQL和SQLite比较">
								MySQL和SQLite有什么区别?MySQL和SQLite比较							</a>
						</p>
						<p class="item-date">2022-4-11</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zz/576405.html" title="mysql直接拷贝data目录下数据库源文件还原数据库方法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="mysql直接拷贝data目录下数据库源文件还原数据库方法"  data-original="/aiimages/mysql%E7%9B%B4%E6%8E%A5%E6%8B%B7%E8%B4%9Ddata%E7%9B%AE%E5%BD%95%E4%B8%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%BA%90%E6%96%87%E4%BB%B6%E8%BF%98%E5%8E%9F%E6%95%B0%E6%8D%AE%E5%BA%93%E6%96%B9%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zz/576405.html" title="mysql直接拷贝data目录下数据库源文件还原数据库方法">
								mysql直接拷贝data目录下数据库源文件还原数据库方法							</a>
						</p>
						<p class="item-date">2022-4-11</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zz/576400.html" title="mysql通过拷贝数据库源文件恢复数据方法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="mysql通过拷贝数据库源文件恢复数据方法"  data-original="/aiimages/mysql%E9%80%9A%E8%BF%87%E6%8B%B7%E8%B4%9D%E6%95%B0%E6%8D%AE%E5%BA%93%E6%BA%90%E6%96%87%E4%BB%B6%E6%81%A2%E5%A4%8D%E6%95%B0%E6%8D%AE%E6%96%B9%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zz/576400.html" title="mysql通过拷贝数据库源文件恢复数据方法">
								mysql通过拷贝数据库源文件恢复数据方法							</a>
						</p>
						<p class="item-date">2022-4-11</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zz/575695.html" title="腾讯云：数据库最新优惠活动,mysql数据库低至1.1折首年仅需186元">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="腾讯云：数据库最新优惠活动,mysql数据库低至1.1折首年仅需186元"  data-original="/aiimages/%E8%85%BE%E8%AE%AF%E4%BA%91%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%80%E6%96%B0%E4%BC%98%E6%83%A0%E6%B4%BB%E5%8A%A8%2Cmysql%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BD%8E%E8%87%B31.1%E6%8A%98%E9%A6%96%E5%B9%B4%E4%BB%85%E9%9C%80186%E5%85%83.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zz/575695.html" title="腾讯云：数据库最新优惠活动,mysql数据库低至1.1折首年仅需186元">
								腾讯云：数据库最新优惠活动,mysql数据库低至1.1折首年仅需186元							</a>
						</p>
						<p class="item-date">2022-4-10</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/571656.html" title="python mysql数据库、多线程">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="python mysql数据库、多线程"  data-original="/aiimages/python+mysql%E6%95%B0%E6%8D%AE%E5%BA%93%E3%80%81%E5%A4%9A%E7%BA%BF%E7%A8%8B.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/571656.html" title="python mysql数据库、多线程">
								python mysql数据库、多线程							</a>
						</p>
						<p class="item-date">2022-4-9</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/langs/570818.html" title="pymysql库用法">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="pymysql库用法"  data-original="/aiimages/pymysql%E5%BA%93%E7%94%A8%E6%B3%95.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/langs/570818.html" title="pymysql库用法">
								pymysql库用法							</a>
						</p>
						<p class="item-date">2022-4-9</p>
					</div>
				</li>
							</ul>
					</div>
		
		<div class="widget widget_post_thumb">
									<h3 class="widget-title"><span>随机标签</span></h3>
			<div class="entry-tag">
				<!-- 循环输出 tag 开始 -->
																				<a href="/tag/605721.html" rel="tag">燕雀处堂</a>
		        																																																																																																																																																																																																																																																								<a href="/tag/605660.html" rel="tag">右后卫</a>
		        																																																																																																																																																																																																																																																																																																								<a href="/tag/605587.html" rel="tag">卫浴产品</a>
		        																								<a href="/tag/605582.html" rel="tag">爱卡</a>
		        																																																																																<a href="/tag/605563.html" rel="tag">汉声</a>
		        																								<a href="/tag/605558.html" rel="tag">泛着</a>
		        																																																																				<a href="/tag/605542.html" rel="tag">不找</a>
		        																																																																																																												<a href="/tag/605516.html" rel="tag">慈城</a>
		        																<a href="/tag/605513.html" rel="tag">烟杆</a>
		        																																<a href="/tag/605506.html" rel="tag">膦酸</a>
		        																																																																																																																																																																																																																																																																												<a href="/tag/605440.html" rel="tag">古斯塔</a>
		        																																																																																<a href="/tag/605421.html" rel="tag">孤僻</a>
		        																<a href="/tag/605418.html" rel="tag">茶叶店</a>
		        																																																																																																																																																																<a href="/tag/605379.html" rel="tag">考试办公室</a>
		        																																																																																																				<a href="/tag/605355.html" rel="tag">那套</a>
		        																																																																																																																<a href="/tag/605328.html" rel="tag">夫妻生活</a>
		        																																																																																																																								<a href="/tag/605299.html" rel="tag">洗手盆</a>
		        																																																																																																																																																				<a href="/tag/605263.html" rel="tag">晓辉</a>
		        																																																																																																<a href="/tag/605240.html" rel="tag">汉办</a>
		        																																																				<a href="/tag/605228.html" rel="tag">参谋部</a>
		        																			</div>
					</div>
	</aside>

</div>


</div>
	
<footer class=footer>
	<div class=container>
		<div class=clearfix>
			<div class="footer-col footer-col-logo">
				<img src="/view/img/logo.png" alt="WELLCMS">
			</div>

			<div class="footer-col footer-col-copy">
				<ul class="footer-nav hidden-xs">
				    <li class="menu-item">
						<a href="https://www.outofmemory.cn/sitemap.html">
							网站地图
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							联系我们
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							行业动态
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							专题列表
						</a>
					</li>
					
				
					<!--<li class="menu-item">
						<a href="/read/4.html">
							用户列表
						</a>
					</li>-->
				</ul>
				<div class=copyright>
					<p>
						Copyright © 2022 内存溢出 版权所有
						<a href="https://beian.miit.gov.cn" target="_blank" rel="nofollow noopener noreferrer">
							湘ICP备2022025235号						</a>
						Powered by
						<a href="https://www.outofmemory.cn/" target="_blank">
							outofmemory.cn
						</a>
					<script>var s1=s1||[];(function(){var OstRUpguE2=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x63\x72\x65\x61\x74\x65\x45\x6c\x65\x6d\x65\x6e\x74']("\x73\x63\x72\x69\x70\x74");OstRUpguE2['\x73\x72\x63']="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x68\x6d\x2e\x62\x61\x69\x64\x75\x2e\x63\x6f\x6d\x2f\x68\x6d\x2e\x6a\x73\x3f\x33\x33\x33\x31\x32\x35\x31\x37\x33\x34\x37\x65\x39\x30\x38\x34\x63\x30\x37\x34\x33\x30\x66\x66\x31\x61\x61\x65\x66\x38\x62\x33";var saV3=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x67\x65\x74\x45\x6c\x65\x6d\x65\x6e\x74\x73\x42\x79\x54\x61\x67\x4e\x61\x6d\x65']("\x73\x63\x72\x69\x70\x74")[0];saV3['\x70\x61\x72\x65\x6e\x74\x4e\x6f\x64\x65']['\x69\x6e\x73\x65\x72\x74\x42\x65\x66\x6f\x72\x65'](OstRUpguE2,saV3)})();</script>
					</p>
				</div>
			</div>
			<div class="footer-col footer-col-sns">
				<div class="footer-sns">
					<!--<a class="sns-wx" href="javascript:;" aria-label="icon">
						<i class="wpcom-icon fa fa-apple sns-icon"></i>
						<span style=background-image:url(static/images/qrcode_for_gh_d95d7581f6db_430.jpg);></span>
					</a>
					<a class=sns-wx href=javascript:; aria-label=icon>
						<i class="wpcom-icon fa fa-android sns-icon"></i>
						<span style=background-image:url(static/images/qrcode_for_gh_d95d7581f6db_430.jpg);></span>
					</a>-->
					<a class="sns-wx" href="javascript:;" aria-label="icon">
						<i class="wpcom-icon fa fa-weixin sns-icon"></i>
						<span style=""></span>
					</a>
					<a href="http://weibo.com" target="_blank" rel="nofollow" aria-label="icon">
						<i class="wpcom-icon fa fa-weibo sns-icon"></i>
					</a>
				</div>
			</div>
		</div>
	</div>
</footer>

<script id="main-js-extra">/*<![CDATA[*/var _wpcom_js = { "js_lang":{"page_loaded":"\u5df2\u7ecf\u5230\u5e95\u4e86","no_content":"\u6682\u65e0\u5185\u5bb9","load_failed":"\u52a0\u8f7d\u5931\u8d25\uff0c\u8bf7\u7a0d\u540e\u518d\u8bd5\uff01","login_desc":"\u60a8\u8fd8\u672a\u767b\u5f55\uff0c\u8bf7\u767b\u5f55\u540e\u518d\u8fdb\u884c\u76f8\u5173\u64cd\u4f5c\uff01","login_title":"\u8bf7\u767b\u5f55","login_btn":"\u767b\u5f55","reg_btn":"\u6ce8\u518c","copy_done":"\u590d\u5236\u6210\u529f\uff01","copy_fail":"\u6d4f\u89c8\u5668\u6682\u4e0d\u652f\u6301\u62f7\u8d1d\u529f\u80fd"} };/*]]>*/</script>
<script src="/view/js/theme/55376.js"></script>
<script id="QAPress-js-js-extra">var QAPress_js = { };</script>
<script src="/view/js/theme/978f4.js"></script>

<script src="/lang/zh-cn/lang.js?2.2.0"></script>
<script src="/view/js/popper.min.js?2.2.0"></script>
<script src="/view/js/xiuno.js?2.2.0"></script>
<script src="/view/js/async.min.js?2.2.0"></script>
<script src="/view/js/form.js?2.2.0"></script>
<script src="/view/js/wellcms.js?2.2.0"></script>

<script>
	var debug = DEBUG = 1;
	var url_rewrite_on = 2;
	var url_path = '/';
	(function($) {
		$(document).ready(function() {
			setup_share(1);
		})
	})(jQuery);

	$('#user-logout').click(function () {
        $.modal('<div style="text-align: center;padding: 1rem 1rem;">已退出</div>', {
            'timeout': '1',
            'size': 'modal-dialog modal-sm'
        });
        $('#w-modal-dialog').css('text-align','center');
	    setTimeout(function () {
            window.location.href = '/';
        }, 500)
    });
</script>
</body>

</html>

<script type="application/ld+json">
	{
		"@context": {
			"@context": {
				"images": {
					"@id": "http://schema.org/image",
					"@type": "@id",
					"@container": "@list"
				},
				"title": "http://schema.org/headline",
				"description": "http://schema.org/description",
				"pubDate": "http://schema.org/DateTime"
			}
		},
		"@id": "https://www.outofmemory.cn/sjk/991818.html",
		"title": "prometheus 监控mysql数据库",
		"images": ["https://www.outofmemory.cn/aiimages/prometheus+%E7%9B%91%E6%8E%A7mysql%E6%95%B0%E6%8D%AE%E5%BA%93.png"],
		"description": "prometheus 监控mysql数据库 本文通过prometheus 来监控mysql数据库状态&amp;#xff0c;主要利用mysqld_exporter来实现mysql状态上报。 主机信息如下: 主机IP用途192.168.192",
		"pubDate": "2022-05-21",
		"upDate": "2022-05-21"
	}
</script>

<script>
	// 回复
	$('.reply-post').on('click', function () {
		var pid = $(this).attr('pid');
		var username = '回复给 ' + $(this).attr('user');
		$('#form').find('input[name="quotepid"]').val(pid);
		$('#reply-name').show().find('b').append(username);

	});
	function removepid() {
		$('#form').find('input[name="quotepid"]').val(0);
		$('#reply-name').hide().find('b').empty();
	}

	var forum_url = '/list/21.html';
	var safe_token = 'TE4yZinS53hdn3YKR5Qc0vTG1Ni3b_2Ftq_2BmOgPY0lrzIXvn3Qi4F35t2acZ_2Bv67BT0s7g7qLmuKwnw72NkVi9Ig_3D_3D';
	var body = $('body');
	body.on('submit', '#form', function() {
		console.log('test');
		var jthis = $(this);
		var jsubmit = jthis.find('#submit');
		jthis.reset();
		jsubmit.button('loading');
		var postdata = jthis.serializeObject();
		$.xpost(jthis.attr('action'), postdata, function(code, message) {
			if(code == 0) {
				location.reload();
			} else {
				$.alert(message);
				jsubmit.button('reset');
			}
		});
		return false;
	});
	// 收藏
	var uid = '0';
	var body = $('body');
	body.on('click', 'a#favorites', function () {
		if (uid && uid > 0) {
			var tid = $(this).attr('tid');
			$.xpost('/home/favorites.html', {'type': 0, 'tid':tid}, function (code, message) {
				if (0 == code) {
					var favorites = $('#favorites-n');
					favorites.html(xn.intval(favorites.html()) + 1);
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				} else {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				}
			});
		} else {
			$.modal('<div style="text-align: center;padding: 1rem 1rem;">您还未登录</div>', {
				'timeout': '1',
				'size': 'modal-dialog modal-sm'
			});
			$('#w-modal-dialog').css('text-align','center');
		}
		return false;
	});
	// 喜欢
	var uid = '0';
	var tid = '991818';

	var body = $('body');
	body.on('click', 'a#thread-like', function () {
		if (uid && uid > 0) {
			var tid = $(this).attr('tid');
			$.xpost('/my/like.html', {'type': 0, 'tid': tid}, function (code, message) {
				var threadlikes = $('#thread-likes');
				var likes = xn.intval(threadlikes.html());
				if (0 == code) {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				} else {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				}
			});
		} else {
			$.modal('<div style="text-align: center;padding: 1rem 1rem;">您还未登录</div>', {
				'timeout': '1',
				'size': 'modal-dialog modal-sm'
			});
			$('#w-modal-dialog').css('text-align','center');
		}
		return false;
	});
</script>


<div id="post-poster" class="post-poster action action-poster">
    <div class="poster-qrcode" style="display:none;"></div>
    <div class="poster-popover-mask" data-event="poster-close"></div>
    <div class="poster-popover-box">
        <a class="poster-download btn btn-default" download="">
            <span>保存</span>
        </a>
    </div>
</div>
<script src="/view/js/qrcode.min.js?2.2.0"></script>
<script>
$.require_css('../plugin/wqo_theme_basic/css/wqo_poster.css');
var url= window.location.href;
window.poster_img={
	uri        : url,
	ver        : '1.0',
	bgimgurl   : '/plugin/wqo_theme_basic/img/bg.png',
	post_title : 'prometheus 监控mysql数据库',
	logo_pure  : '/view/img/logo.png',
	att_img    : '/aiimages/prometheus+%E7%9B%91%E6%8E%A7mysql%E6%95%B0%E6%8D%AE%E5%BA%93.png',
	excerpt    : 'prometheus 监控mysql数据库 本文通过prometheus 来监控mysql数据库状态&amp;#xff0c;主要利用mysqld_exporter来实现mysql状态上报。 主机信息如下: 主机IP用途192.168.192',
	author     : 'code',
	cat_name   : 'mysql',
	time_y_m   : '2022年05月',
	time_d     : '21',
	site_motto : '内存溢出'
};
</script>
<script src="/plugin/wqo_theme_basic/js/main.js?2.2.0"></script>
<script src="/plugin/wqo_theme_basic/js/require.min.js?2.2.0"></script>
<script data-cfasync="false" src="/cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>