Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
For Linux and other Unix-like platforms: mysqlbackup does not record file ownership or permissions of the files that are backed up. To ensure no file permission issues prevent a server to be backed up, restored, and restarted successfully, it is ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-password-validation-plugins.html
The instructions are based on the source code in the plugin/password_validation directory of MySQL source distributions. Note The plugin form of validate_password from older MySQL releases is deprecated and is subject to removal in a future version ... This section describes how to write a server-side password-validation ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-load-model.html
A model can only be loaded by the MySQL user that created the model unless you grant access to other users. The following example loads an AutoML model from the model catalog by using the session variable mysql> CALL sys.ML_MODEL_LOAD(@census_model, ... You must load a machine learning model from the model catalog before running AutoML routines other than ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-row.html
mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), @census_model); The following example loads the trained model. mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-active.html
ML_MODEL_ACTIVE Syntax mysql> CALL sys.ML_MODEL_ACTIVE (user, model_info); ML_MODEL_ACTIVE parameters: user: The user to provide information for. Use the ML_MODEL_ACTIVE routine to check which models are loaded and active for which users. All ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-predict-row.html
mysql> SELECT sys.ML_PREDICT_ROW(JSON_OBJECT("column_name", value, "column_name", value, ...), model_handle, options); Run ML_PREDICT_ROW on multiple rows of data by specifying the columns as key-value pairs in JSON format and select from a table.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-score.html
ML_SCORE Syntax mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['threshold', 'N'] ['topk', 'N'] ['remove_seen', ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or ...The built-in functions can be invoked in any schema and require no qualifier, unlike the sys functions, which require either a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The order in which matching occurs matters because different matching setup_objects rows can ... The setup_objects table controls whether the Performance Schema monitors particular ...