Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/database-connection-example.html
The code that is needed to connect to a MySQL document store looks a lot like the traditional MySQL connection code, but now applications can establish logical sessions to MySQL server instances running the X Plugin. Sessions are produced by the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisor-scripting-blackouts.html
It is also possible to manage blackouts from the command line, or a script. You can run the commands from the command line or add to a text file and save it as *.sh or *.bat depending on your platform. Note On Unix systems, use the chmod +x ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
To create a new Advisor, click the Create Advisor button on the Advisors page. To create an Advisor based on an existing one, select Copy Advisor menu item from the Advisor menu. You can edit any Advisor element during the copying process, unlike ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-notification-blackouts.html
During maintenance periods for database servers, you can suspend Event Handlers. Agents continue to collect data, data is stored in the repository, and events are generated and displayed. Notifications, such as SNMP traps, emails and so on, are not ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-features-qrti.html
It is a "quality of service" measurement for each query, and uses the Apdex formula for that calculation: Apdex on Wikipedia. Reading QRTi Values The queries listed on the Query Analyzer page also have a color-coded pie chart representing a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-lock-waits-ref.html
To open the Lock Waits reports, select Lock Waits from the Reports & Graphs menu. InnoDB Row Lock Waits This report retrieves data on InnoDB row locks from sys.x$innodb_lock_waits. For more information on the data retrieved in this report, see The ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-gui-ref.html
This section describes how to install the Agent using the Installation Wizard. Note To install to the default directory (/opt/mysql/enterprise/agent), log in as root first. To automatically start the agent upon rebooting, you must install while ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-remote.html
Typically, the Agent runs on the same machine as the MySQL servers that it is monitoring. To monitor MySQL servers running on remote hosts, you can install the Agent on a machine other than the one hosting the MySQL server. The process for ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-upgrade-sm-from-30x.html
You must upgrade your MySQL Enterprise Service Manager installation first, and your agents after the MySQL Enterprise Service Manager installation completes successfully. Upgrade Installer The name of the upgrade file varies, but includes the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using.html
The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution times. Similar queries with different literal values are combined for reporting ...