Usage of /usr/bin/nri-mysql:
-cache_ttl duration
Optional. The time the integration considers a temporal stored value as valid (defaults to 6 minutes left empty). (default 6m0s)
-database string
Name of the database.
-enable_query_monitoring
Enable collection of detailed query performance metrics.
-enable_tls
Use a secure (TLS) connection.
-events
Publish events data.
-excluded_performance_databases string
A JSON array that lists databases to be excluded from performance metrics collection. System databases are always excluded. (default "[]")
-extended_backup_history_metrics
Enable collection of historical backup metrics from performance_schema.
-extended_backup_metrics
Enable collection of active backup operation metrics.
-extended_innodb_metrics
Enable collection of extended InnoDB metrics.
-extended_metrics
Enable collection of extended metrics.
-extended_my_isam_metrics
Enable collection of extended MyISAM metrics.
-extra_connection_url_args string
Additional connection parameters in the format attr1=val1&attr2=val2.
-hostname string
Hostname or IP address where MySQL is running. (default "localhost")
-insecure_skip_verify
Skip TLS certificate verification when connecting.
-inventory
Publish inventory data.
-metadata
Add customer defined key-value attributes to the samples.
-metrics
Publish metrics data.
-nri_add_hostname
Add hostname attribute to the samples.
-nri_cluster string
Optional. Cluster name
-nri_service string
Optional. Service name
-old_passwords
Allow the use of old passwords: https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_old_passwords
-password string
Password for the specified user. (default "password")
-port int
Port number on which MySQL server is listening. (default 3306)
-pretty
Print pretty formatted JSON.
-query_monitoring_count_threshold int
Query count limit for fetching grouped slow and individual query performance metrics. (default 20)
-query_monitoring_response_time_threshold int
Threshold in milliseconds for query response time to fetch individual query performance metrics. (default 1)
-remote_monitoring
Indicates if the monitored entity is remote. Set to true if unsure.
-show_version
Display build information and exit.
-slow_query_monitoring_fetch_interval int
Fetch interval in seconds for grouped slow queries. Should match the interval in mysql-config.yml. (default 30)
-socket string
Path to the MySQL socket file.
-temp_dir string
Optional. Integrations path to store temporal data (defaults to os.tempDir if left empty).
-username string
Username for database access. (default "root")
-verbose
Print more information to logs.
Options (33)
| Option | Description | Source |
|---|---|---|
-cache_ttl duration | Optional. | help |
-database string | Name of the database. | help |
-enable_query_monitoring | Enable collection of detailed query performance metrics. | help |
-enable_tls | Use a secure (TLS) connection. | help |
-events | Publish events data. | help |
-excluded_performance_databases string | A JSON array that lists databases to be excluded from performance metrics collection. | help |
-extended_backup_history_metrics | Enable collection of historical backup metrics from performance_schema. | help |
-extended_backup_metrics | Enable collection of active backup operation metrics. | help |
-extended_innodb_metrics | Enable collection of extended InnoDB metrics. | help |
-extended_metrics | Enable collection of extended metrics. | help |
-extended_my_isam_metrics | Enable collection of extended MyISAM metrics. | help |
-extra_connection_url_args string | Additional connection parameters in the format attr1=val1&attr2=val2. | help |
-hostname string | Hostname or IP address where MySQL is running. | help |
-insecure_skip_verify | Skip TLS certificate verification when connecting. | help |
-inventory | Publish inventory data. | help |
-metadata | Add customer defined key-value attributes to the samples. | help |
-metrics | Publish metrics data. | help |
-nri_add_hostname | Add hostname attribute to the samples. | help |
-nri_cluster string | Optional. | help |
-nri_service string | Optional. | help |
-old_passwords | Allow the use of old passwords: https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_old_passwords | help |
-password string | Password for the specified user. | help |
-port int | Port number on which MySQL server is listening. | help |
-pretty | Print pretty formatted JSON. | help |
-query_monitoring_count_threshold int | Query count limit for fetching grouped slow and individual query performance metrics. | help |
-query_monitoring_response_time_threshold int | Threshold in milliseconds for query response time to fetch individual query performance metrics. | help |
-remote_monitoring | Indicates if the monitored entity is remote. | help |
-show_version | Display build information and exit. | help |
-slow_query_monitoring_fetch_interval int | Fetch interval in seconds for grouped slow queries. | help |
-socket string | Path to the MySQL socket file. | help |
-temp_dir string | Optional. | help |
-username string | Username for database access. | help |
-verbose | Print more information to logs. | help |