Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-using-developing.html
MySQL Router usage does not require specific libraries or interfaces. Aside from managing the MySQL Router instance, write your application as if MySQL Router was a typical MySQL instance. The only difference when using MySQL Router is how you make ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-configuration.html
To enable read-write splitting, the following router options must be enabled: access_mode: must be set to auto. Note It is possible to define read_write and read_only access_mode values per session, only. destinations: must be set to a ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
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 DELETE. EXPLAIN, DESCRIBE, or DESC which are not followed by UPDATE or DELETE. If they start ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-train.html
After preparing the data for a classification model, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for a Classification Model. Training the Model Train the model with the ML_TRAIN routine and use the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ease-of-use.html
The AutoML feature of MySQL AI is purpose-built for ease of use. With AutoML and a set of training data, you can train a predictive machine learning model with a single call to the ML_TRAIN SQL routine. For example: CALL ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model handle is generated or set by the user when the ML_TRAIN ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-onnx-metadata.html
To learn more about model metadata in the model catalog, see Model Metadata. ONNX Inputs Info Use the data_types_map to map the data type of each column to an ONNX model data type. For example, to convert inputs of the type tensor(float) to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prediction-intervals.html
Prediction intervals for forecasting models specify upper and lower bounds on predictions for forecasting based on level of confidence. For example, for a prediction interval of 0.95 with a lower bound of 25 units and an upper bound of 65 units, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
You can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine. Overview The TRAIN_TEST_SPLIT routine takes your datasets and prepares new tables for training and testing machine learning models. Two new tables in the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-train.html
After preparing the data for a regression model, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for a Regression Model. Training the Model Train the model with the ML_TRAIN routine and use the ...