Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
(WL #15243) New functions have been added to MySQL HeatWave AutoML to help you manage models: When you run the ML_TRAIN routine on a training dataset, you can now specify a model handle to use for the model instead of the generated one. A new column ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
The FILES table has these columns: FILE_ID For InnoDB: The tablespace ID, also referred to as the space_id or fil_space_t::id. For NDB: For a Disk Data undo log file, the auto-generated ID number of the log file group to which the log file belongs.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. The ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanfilter.html
Description This type represents a condition based on the comparison of a column value with some arbitrary value—that is, a bound condition. When used in comparisons with COND_EQ, COND_NE, COND_LT, COND_LE, COND_GT, or COND_GE, fixed-length ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
index_stats: Used to store dynamic index statistics generated when ANALYZE TABLE is executed. table_stats: Information about dynamic table statistics generated when ANALYZE TABLE is executed. As of yet, there are no INFORMATION_SCHEMA tables that ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-score.html
ML_SCORE scores a model by generating predictions using the feature columns in a labeled dataset as input and comparing the predictions to ground truth values in the target column of the labeled dataset. The dataset used with ML_SCORE should have ...For example, you might reserve 20 to 30 percent of the labeled training data for ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys. ORDER BY column statement run against a partitioned table ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
How do I use the SSL Certificate wizard to enable SSL for both my MySQL server and MySQL client? Execute the wizard to generate the SSL certificates, and then modify your MySQL server's configuration file (my.cnf or my.ini) accordingly. You can ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
By logging only those columns required for uniquely identifying and executing changes on each row (as opposed to all columns) for each row change, it is possible to save disk space, network resources, and memory usage. You can determine whether full ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). The following table lists each built-in (native) function and operator and provides a short description of each one. For a ...