Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-information-schema-plugins.html
This section describes how to write a server-side INFORMATION_SCHEMA table plugin. For example code that implements such plugins, see the sql/sql_show.cc file of a MySQL source distribution. You can also look at the example plugins found in the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-11.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed X DevAPI: The locking options lockShared() and lockExclusive(), available when retrieving data from collection.find() and table.select(), now also accept an optional locking ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-generate-explanation.html
permutation_importance is the selected prediction explainer to use to generate explanations. After training a classification model, you can query the default model explanation or query new model explanations. Explanations help you understand which ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explainers.html
mysql> SELECT column FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle=model_handle; The following example retrieves the model explainer column from the model catalog of the previously trained model. After the ML_TRAIN routine, use the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-explanations.html
mysql> SELECT JSON_PRETTY(model_explanation) FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle='regression_use_case'; +------------------------------------------------------------------------------------------------------------------------+ | ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-unload-model.html
mysql> CALL sys.ML_MODEL_ACTIVE('all', @model_info); Select the session variable created to view all loaded models. Before You Begin Review the following Train a Model Load a Model Unload a Model You can verify what models are currently loaded with ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-an-anomaly-detection-model.html
If needed, you can also query all the columns from the table (SELECT * FROM credit_card_predictions_semi) to review all the data at once. To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
For example: mysql> SELECT sys.ML_GENERATE(@query, JSON_OBJECT("task", "generation", "model_id", "llama3.2-3b-instruct-v1", "language", "en")); Text-based content that is generated by the LLM in response to your query is printed as output. For ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
For example: mysql> SELECT sys.ML_GENERATE(@text, JSON_OBJECT("task", "summarization", "model_id", "llama3.2-3b-instruct-v1", "language", "en")); A text summary generated by the LLM in response to your query is printed as output. For example: mysql> ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...