Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-forecasting-model.html
Even though the table has labels for the demand target column, the column is not considered when generating predictions. Any extra columns, for example endogenous_variables, are ignored for the prediction, but included in the output table. To ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-similar-items.html
Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a Recommendation Model Generating Similar Items When you run ML_PREDICT_TABLE to generate similar ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-similar-users.html
Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a Recommendation Model Generating Similar Users When you run ML_PREDICT_TABLE to generate similar ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-train-test-split.html
Two new tables in the same database are created with the following names: [original_table_name]_train [original_table_name]_test The split of the data between training and testing datasets depends on the machine learning task. Order the table by the ... The TRAIN_TEST_SPLIT routine automatically splits your data into training and testing ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Pluggable authentication makes it possible for clients to ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
Unless otherwise specified, functions handle their unit argument as follows: A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. The OpenGIS specification defines the following functions to test the relationship ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported.
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Thus, if a table is touched for the first time, it implicitly starts a ...In ...