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
auto: the server is selected based on the type of transaction, reads are targetted to read_only servers, writes to read_write servers. To enable read-write splitting, the following router options must be enabled: access_mode: must be set to auto.
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
mysql> SELECT model_id, model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle = 'classification_use_case'; +----------+----------------------------------------------+-------------------------------------+ | model_id | ... 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-ease-of-use.html
For example, the following call to the ML_PREDICT_TABLE routine generates predictions for a table of input data: CALL sys.ML_PREDICT_TABLE('heatwaveml_bench.census_test', @census_model, 'heatwaveml_bench.census_predictions', NULL); All AutoML ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-catalog-table.html
model_type The type of model (algorithm) selected by ML_TRAIN to build the model. 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 ...
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
For example, for a prediction interval of 0.95 with a lower bound of 25 units and an upper bound of 65 units, you are 95% confident that product ABC will sell between 25 and 65 units on a randomly selected day. Prediction intervals for forecasting ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
If this is set to NULL, then the default value of false is selected. 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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-train.html
mysql> SELECT model_id, model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle = 'regression_use_case'; +----------+----------------------------------------------+----------------------------------------+ | model_id | ... After preparing the data for a regression model, you can train the ...