Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-intro-advisor-page-ref.html
To display the Advisors page, select Advisors from the Configuration menu. Figure 19.1 Manage Advisors Page The components and controls of the Manage Advisors page are as follows: Table 19.1 Manage Advisors Page Controls Name Description Edit ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
MySQL Enterprise Monitor Agent requires a user configured within each MySQL instance that is being monitored with suitable privileges to collect information about the server, including variable names, replication, and storage engine status ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance Schema. Rather than drop the suggested indexes, make them invisible first, ...Autopilot Indexing only evaluates SQL statements in the SQL statement digest history that access existing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
Queries on these tables will | | no longer be offloaded to HeatWave. You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
Change Propagation Failure A change propagation failure can cause tables in MySQL HeatWave to become stale, and queries that access stale tables are not offloaded to MySQL HeatWave for processing. After tables are loaded into MySQL HeatWave, data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in MySQL HeatWave User Guide to provide answers to MySQL HeatWave-related questions. Note This quickstart assumes that you are familiar with MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
InputTableName: the name of the table that contains the column where your input queries are stored. OutputColumn: the name for the new column where you want to store the output generated for the input queries. As of MySQL 9.4.1, MySQL HeatWave ...