Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-limitations.html
MySQL HeatWave AutoML does not support TEXT columns with NULL values. MySQL HeatWave AutoML does not support target columns (a column with ground truth values) with a TEXT data type. MySQL HeatWave AutoML does not support recommendation tasks with ...Text Handling Limitations AutoML only supports datasets in the English ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-monitoring.html
mysql> SHOW GLOBAL STATUS LIKE 'rapid_ml_status'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | rapid_ml_status | ON | +-----------------+-------+ The following example queries the rapid_ml_status status through ... You can monitor the status of AutoML by querying the rapid_ml_status variable or by querying the ML_STATUS column of the performance_schema.rpd_nodes ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-prediction.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('topic_modeling_use_case', NULL); Run topic modeling on the dataset by using the ML_PREDICT_TABLE routine. mysql> CALL ... After ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-chat.html
This topic contains the following sections: HEATWAVE_CHAT Syntax @chat_options Parameters Syntax Examples See Also HEATWAVE_CHAT Syntax mysql> CALL sys.HEATWAVE_CHAT('QueryInNaturalLanguage'); The HEATWAVE_CHAT routine accepts one input parameter: ... The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-vector-store-load.html
The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are , and loads the embeddings into a new vector store table. This routine creates an asynchronous task which loads vector store tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). row *************************** LOGGED: 2020-08-06 09:25:00.338624 THREAD_ID: 0 PRIO: System ERROR_CODE: ...Typically, the server writes diagnostics to a file on the server host or to a system log ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-localization.html
If this is the first time launching the MySQL Enterprise Monitor User Interface, you must set your time zone and locale. Setting the time zone ensures that you have an accurate time reference for any notifications from the MySQL Enterprise Advisors. Warning Set the time zone (and the system clock) correctly because this setting affects how MySQL Enterprise Service Manager's graphs display ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
MySQL uses mmap() when possible to perform memory mapping on compressed tables. If mmap() does not work, MySQL falls back to normal read/write file operations. Please note the following: If the mysqld server was invoked with external locking ...When ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
(See Bug #42849.) Note It is also possible in MySQL 8.4 to use UNIX_TIMESTAMP(timestamp_column) as a partitioning expression for tables that are partitioned by LIST. However, MySQL must be able to evaluate the expression's return value as part of a ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. RAID N can be a problem if you have many writes, due to the time required to update the parity bits. You can also set the parameters for ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...