Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-dns-srv.html
X DevAPI supports the use of DNS SRV records for connecting to MySQL servers. A client that receives a DNS SRV lookup result attempts to connect to the MySQL server on each of the listed hosts in order of preference, based on the priority and ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
Important MySQL Enterprise Service Manager 8.0's bundled repository is MySQL Server 5.7.22. Important Due to password plugin changes in the server, only MEM 8.0 and later support monitoring MySQL 8.0.11, or higher. For more information on the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
The main queries enable you to retrieve data from the monitored server. To avoid this, test your query thoroughly on the monitored server. If the custom data collection is deployed on multiple agents, it must be tested on each monitored server and ...When defining queries, the following restrictions apply: The query must be defined within a <![CDATA[]]> ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisor-scripting-blackouts.html
The following blackout types are described: Server Blackout: describes how to apply or remove a blackout on a MySQL instance. Server Blackout The blackout command enables you to blackout individual MySQL instances. One of the following: ... It is ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
An expression can be as simple as a single server parameter or can be complex, combining multiple parameters with mathematical operations. For example, if enabling binary logging is a best practice for a production server (as Oracle recommends), ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-events.html
Warning: The event is something to investigate and schedule for correction, but does not immediately affect the operation of your server, such as free space on a disk, or a table cache is inadequately sized. Notice events call attention to issues ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-performance-schema.html
Query Analyzer data is automatically collected and displayed by monitoring MySQL Server 5.6.14 or greater, using the Performance Schema Statement Digests feature (Performance Schema Statement Digests and Sampling) added in MySQL 5.6. Note It is not ...Note The maximum space available for digest computation is 1024 bytes by default; queries exceeding this length are ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/platforms-prereqs-reference.html
General Platform Recommendations The following are recommended: Ensure that your Service Manager and Agent hosts are synchronized to the same time server. MySQL Requirements This section describes the MySQL Server requirements for MySQL Enterprise ... The supported platforms for MySQL Enterprise Service Manager and MySQL Enterprise Monitor Agent are listed at the following locations: MySQL Enterprise Service Manager Supported Platforms MySQL Enterprise Monitor Agent Supported Platforms For platform support updates, see MySQL Product Support ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/precondition-queries-reference.html
For example, they are used in the default advisors to check the MySQL server version, because some main queries cannot be executed on older versions of the server. The following is an example of a precondition query which checks the version of the ...Precondition queries determine that specific conditions are true before executing the main ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
When installed, the audit plugin enables the MySQL server to produce a log file containing an audit record of server activity. audit-log=FORCE_PLUS_PERMANENT Restart the server to apply the configuration change: $> systemctl restart mysqld By ...