Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations-ml-explain-row.html
The column names must match the feature column names in the trained table. mysql> CALL sys.ML_EXPLAIN ('table_name', 'target_column_name', model_handle, [options]); The following example runs the shap explainer. mysql> CALL ... ML_EXPLAIN_ROW ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations.html
Prediction explanations are generated by running ML_EXPLAIN_ROW or ML_EXPLAIN_TABLE on unlabeled data. You can train the following prediction explainers: The Permutation Importance prediction explainer, specified as permutation_importance, is the ...The data must have the same feature columns as the data used to train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-limitations.html
Memory Limitations The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. Routine and Query Limitations ML_EXPLAIN_TABLE and ML_PREDICT_TABLE are compute intensive processes, with ML_EXPLAIN_TABLE being the most ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. The following example queries the model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-viewing.html
To view the details for the models in your model catalog, query the MODEL_CATALOG table. Before You Begin Review the following: Create a Machine Learning Model The Model Catalog View Details for Your Models The following example queries model_id, ...View Model Explanations The ML_EXPLAIN routine generates model explanations and stores them in the model ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-onnx-import-overview.html
You cannot directly load models in ONNX format (.onnx) into a MySQL table. AutoML supports the following ONNX model types: An ONNX model that has only one input, and it is the entire MySQL table. An ONNX model that has more than one input, and each ...The models require string serialization and conversion to Base64 encoding before you use the ML_MODEL_IMPORT ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.5/en/news-9-5-0.html
The error occurred on the invalidEngineForeignKey upgrade check if a table name contained non-letter characters such as hyphens. (Bug #38408207) When using anonymous arguments with the -- util copyTables command, the error message did not clearly ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-x-protocol-and-x-devapi.html
Default Value 10000 Since Version 8.0.13 xdevapi.connection-attributes An X DevAPI-specific comma-delimited list of user-defined "key=value" pairs, in addition to standard X Protocol-defined "key=value" pairs, to be passed to MySQL Server for ...If ...
https://dev.mysql.com/doc/internals/en/bas-ext.html
By providing a list of extensions, storage engines can in many cases omit the [custom-engine.html#custom-engine-api-reference-delete_table delete_table()] method as the MySQL server will close all references to the table and delete all files with ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
7.2.2.5.1 Overview Index Merge is used when table condition can be converted to form: cond_1 OR cond_2 ... OR cond_N The conditions for conversion are that each cond_i can be used for a range scan, and no pair (cond_i, cond_j) uses the same index.