Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following Account Management statements: GRANT, REVOKE, RENAME USER, CREATE ROLE, CREATE USER, DROP ROLE, DROP USER, SET PASSWORD, SET ROLE, SET DEFAULT ROLE. The following database administration statements: SHOW CREATE..., SHOW VARIABLES, SHOW ... The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-train.html
Training the Model Train the model with the ML_TRAIN routine and use the training_data table previously created. Before training the model, it is good practice to define the model handle instead of automatically creating one. The following example ... After preparing the data for a classification model, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-train.html
Training the Model Train the model with the ML_TRAIN routine and use the house_price_training table previously created. Before training the model, it is good practice to define the model handle instead of automatically creating one. The following ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-train.html
Therefore, you cannot use the following options for topic modeling: model_list optimization_metric exclude_model_list exclude_column_list include_column_list Unsupported Routines You cannot run the following routines for topic modeling: ML_EXPLAIN ... After preparing the data for topic modeling, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
Unsupported Routines You cannot run the following routines for a trained forecasting model: ML_EXPLAIN ML_EXPLAIN_ROW ML_EXPLAIN_TABLE ML_PREDICT_ROW Training the Model After following the steps to Prepare Data for Forecasting Model, train the model ... After preparing the data for a forecasting model, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-export.html
Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined table. To learn how to use ML_MODEL_EXPORT to share models, see Grant Other Users Access to a Model. Syntax Examples An example that exports an AutoML model ...ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT DEFAULT NULL model_metadata: JSON See Model ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Object Changed: Database Has Been Created For development environments, changes to databases and objects may be a normal occurrence, but not for production environments. Default frequency ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. However, it is not difficult in MySQL to create partitioning ...