![]() If you do not see the plugin, see Troubleshooting Linux. On the Integrations Page you will see the MySQL plugin available if the previous steps were successful. Restart the agent: sudo service swisnapd restartĮnable the MySQL plugin in the AppOptics UI If set to false, InnoDB metrics will not be collected, and corresponding metrics needs to be commented out in task file. You can get more information about InnoDB from the MySQL documentation. If set to true, the plugin will collect extended metrics from the InnoDB storage engine for your instance/cluster. The key mysql_use_innodb is an optional setting that defaults to false. This plugin is tested to run against both versions of the database software, so enabling the TCP connection on your SQL instance/cluster will be sufficient. We recommend creating a new user with full read rights for use with this plugin. The credentials should be entered in the following format: the root user for monitoring can cause compatibility issues. It accepts single line or multiline (embedded yaml) connection strings. The key mysql_connection_string is a required setting that should set the connection information to the database instance. Mysql_connection_string: multiple connection strings Update the /opt/SolarWinds/Snap/etc/plugins.d/mysql.yaml configuration file with settings specific to your database instance, for example: collector: ![]() Make a copy of the mysql example configuration file /opt/SolarWinds/Snap/etc/plugins.d/, renaming it to /opt/SolarWinds/Snap/etc/plugins.d/mysql.yaml: sudo cp -p /opt/SolarWinds/Snap/etc/plugins.d/ /opt/SolarWinds/Snap/etc/plugins.d/mysql.yaml It defines the plugin and task file to be loaded by the agent, but requires you to provide the correct settings for your database. The agent provides an example configuration file to help you get started quickly. This plugin requires the connection credential to the MySQL or MariaDB instance to monitor, please refer to your database manual on setting up the credential. The mysql plugin is included with the SolarWinds Snap Agent by default, please follow the directions below to enable it for an agent instance. ![]() Including information for queries, on your database instance(s). It gathers information about resource usage and performance characteristics, This plugin collects runtime metrics from MySQL or MariaDB instances. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |