Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-statements.html
Table 5.7 Statements Performance Page Regions GraphDescriptionDML Statements Graphs the number and type of DML statements. Index Usage Ratio Graphs the change in rows read by indexes versus rows read by table scans. Temporary Tables Graphs the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-troubleshooting-agent-start.html
Compare the values of the Host, and User fields in the mysql.user table with the values shown in the etc/agentManaged/mysqlConnection<id>/bean/json file. On MySQL 5.5, or earlier, MySQL Enterprise Monitor Agent and MySQL Enterprise Service Manager ... The first step in troubleshooting the agent is finding out whether it is running or ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-menus-navigation-sidebar.html
This report enables you to view detailed table statistics in both table and treemap forms. This section describes the navigation menus of the user interface. That is, they are displayed according to the selection made in the View Filters. For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
The MySQL Process Discovery Advisor enables you to find and, optionally, establish a connection with unmonitored MySQL instances. Table 21.1 MySQL Process Discovery Advisor Controls Name Description Attempt Connection Whether or not to attempt a ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
show_create_table_skip_secondary_engine Command-Line Format --show-create-table-skip-secondary-engine[={OFF|ON}] System Variable show_create_table_skip_secondary_engine Scope Session Dynamic Yes SET_VAR Hint Applies Yes Type Boolean Default Value ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
Manually loading data into MySQL HeatWave involves preparing tables on the DB System and executing load statements. When MySQL HeatWave loads a table, the data is sharded and distributed among MySQL HeatWave nodes. After a table is loaded, DML ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
If you find unsupported format files, then try one of the following: Delete the files with unsupported formats from the folder, and run the VECTOR_STORE_LOAD command again to load the vector embeddings into the vector store table again. Move the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Define all tables accessed by the query using RAPID as the secondary engine. What's Next Learn how to perform the following tasks: Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes .
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
Ensure that all the tables included in the view are loaded in MySQL HeatWave. Queries executed on views are subject to the same offload prerequisites and limitations as queries executed on tables. In the following example, a view is created on the ... This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-row.html
A table can include extra columns, and still use the MySQL HeatWave AutoML model. This allows side by side comparisons of target column labels, ground truth, and explanations in the same table. The column names must match the feature column names in ... The ML_EXPLAIN_ROW routine generates explanations for one or more rows of unlabeled ...