Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-starting-agent-unix.html
If the agent is not running, use the following command to view the last ten entries in the general Agent log file: $> tail /opt/mysql/enterprise/agent/logs/mysql-monitor-agent.log For further information on troubleshooting the agent, see Section ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-asset-management-delete.html
This section describes how to delete assets, and groups of assets, from MySQL Enterprise Monitor's inventory, from the user interface. The delete process removes all record of an asset or group of assets from the internal record of MySQL Enterprise ...Important Deleting assets from the inventory does not delete or uninstall assets from their installed ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
All versions prior to MySQL 8.0.32 use the heatwave_advisor_report and heatwave_load_report tables for reporting Autopilot Advisor and load activities. It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. For a list of data types that MySQL HeatWave supports, see Section 4.2.1, “Supported Data Types for MySQL HeatWave”. With MySQL version 8.2.0 or ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() Bit functions and operators. For example: mysql> SELECT CONVERT_TZ(O_ORDERDATE, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-running-queries.html
When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for accelerated processing. Simply run the query from a client, application, or interface ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-row.html
mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), @census_model); The following example loads the trained model. mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, limit operations to batches of rows by splitting large tables into smaller tables by using the batch_size option. For MySQL 9.4.1 and later, if ML_PREDICT_TABLE takes a ... ML_PREDICT_TABLE generates predictions for an entire table of trained ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
Prepare Data for a Semi-Supervised Anomaly Detection Model The semi-supervised anomaly detection model (available as of MySQL 9.0.1-u1) looks for unusual patterns in credit card transactions. To prepare the data for the semi-supervised anomaly ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
Possible values are meta.llama-3.3-70b-instruct, llama3.1-8b-instruct-v1, llama3.2-3b-instruct-v1, and as of MySQL 9.5.0, you can select one of the OCI Generative AI Service LLMs available in MySQL HeatWave. To learn how to download and then load ...