Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-an-anomaly-detection-model.html
mysql> CALL sys.ML_TRAIN('anomaly_log_data.training_data', NULL, JSON_OBJECT('task', 'log_anomaly_detection', 'exclude_column_list', JSON_ARRAY('log_id', 'timestamp', 'target'), 'logad_options', JSON_OBJECT('embedding_model', 'all_minilm_l12_v2', ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
The DEFINER clause specifies the MySQL account to be used when checking access privileges at event execution time. The ENDS keyword is followed by a timestamp value that tells MySQL when the event should stop repeating. The ON SCHEDULE clause may ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
However, prepared statements take time to prepare and consume memory in the MySQL server until they are closed. However, prepared statements take time to prepare and consume memory in the MySQL server until they are closed, so it is important to use ...Excessive Disk Temporary Table Usage Detected If the space required to build a temporary table exceeds either tmp_table_size or max_heap_table_size, MySQL creates a disk-based table in the server's tmpdir ...
https://dev.mysql.com/doc/connectors/en/connector-j-testing.html
To run the tests, in addition to fulfilling the requirements described in Section 3.3.3, “Installing from Source”, you must also set the following properties in the build.properties file or through the Ant -D options: com.mysql.cj.testsuite.jvm: ... The Connector/J source code repository or packages that are shipped with source code include an extensive test suite, containing test cases that can be executed ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-source-windows.html
The MySQL client library and include files from MySQL 8.0 or higher for Connector/ODBC 9.3, or MySQL 5.7 for Connector/ODBC 5.3. Set MYSQL_DIR to the MySQL server installation path, while using the short-style file names. cmake looks for the client ... You only need to build Connector/ODBC from source on Windows to modify the source or installation ...
https://dev.mysql.com/doc/connectors/en/connector-python-installation-source.html
Prerequisites for Compiling Connector/Python with the C Extension Source distributions include the C Extension that interfaces with the MySQL C client library. For installing the classic interface only: MySQL Server binaries (server may be installed ...Source distributions are packaged in two formats: Zip archive format (.zip file) Compressed tar archive format (.tar.gz file) Either of the two packaging formats can be used on any platforms, but Zip archives are more commonly used on Windows systems and tar archives on Unix and Unix-like ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
mysql> CALL sys.HEATWAVE_UNLOAD_all ([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } } Auto Unload Syntax for MySQL 8.3.0-u2 and Earlier ...This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The use of ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. The Auto Shape Prediction feature in MySQL HeatWave Autopilot uses MySQL statistics for the workload to assess the suitability of the current shape. Monitor MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. SELECT statements are supported, but only the SELECT portion is offloaded to MySQL HeatWave. If autocommit is disabled, MySQL ...