Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-configuration-file-locations.html
For example: select JSON_PRETTY(attributes) from mysql_innodb_cluster_metadata.routers; | { "ROEndpoint": "6447", "RWEndpoint": "6446", "ROXEndpoint": "6449", "RWXEndpoint": "6448", "RWSplitEndpoint": "6450", "MetadataUser": "mysql_router1_plje99d", ... MySQL Router scans for the default configuration files at startup, and optionally loads user-defined configuration files at runtime from the command ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
MySQL Router supports tracing of statements as they are processed by MySQL Router from client to server and the response to the client. Configuration To configure ROUTER SET trace you must add the following to your MySQL Router configuration file: ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-anomaly-detection-logs.html
You have the option to select the keyword model and any embedding model supported by MySQL AI with the training options keyword_model and embedding_model. To review supported embedding models, run the following query: SELECT sys.ML_LIST_LLMS(); and ... Anomaly detection for logs allows you to detect anomalies in log ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-generate-prediction.html
If needed, you can also query all the columns from the table (SELECT * FROM classification_predictions) to review all the data at once. To generate predictions, use the sample data from the testing_data dataset. Even though the table has labels for ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-score.html
mysql> SELECT @classification_score; +-----------------------+ | @classification_score | +-----------------------+ | 0.800000011920929 | +-----------------------+ 1 row in set (0.0431 sec) If done working with the model, unload it with the ... After ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-forecasting-model-types.html
Selecting Forecasting Models To specify which models that are considered for training, use the model_list option and enter the appropriate model names. If the model_list option is not set, then ML_TRAIN considers all supported models during the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-load-model.html
You must load a machine learning model from the model catalog before running AutoML routines other than ML_TRAIN. A model remains loaded and can be called repetitively by AutoML routines until it is unloaded using the ML_MODEL_UNLOAD routine, or ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-quality.html
The metric you select to score the model must be compatible with the task type and the target data. mysql> SELECT @score; +--------------------+ | @score | +--------------------+ | 0.8888888955116272 | +--------------------+ 1 row in set (0.0409 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Before You Begin Review how to Create a Machine Learning Model. Delete a Model To delete a model from the model catalog table: Query the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-monitoring.html
mysql> SELECT VARIABLE_NAME, VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE 'rapid_ml_status'; +-----------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------+----------------+ | ... You can ...