Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
Executing internal-use BINLOG statements to apply mysqlbinlog output, provided that the account also has permission for the tables and operations in those statements. Updating the system tables mysql.gtid_executed, mysql.slave_relay_log_info, ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
To revoke all privileges from a user, use one of the following statements; either of these statements drops all global, database, table, column, and routine privileges for the named users or roles: REVOKE ALL PRIVILEGES, GRANT OPTION FROM ...[IGNORE ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
For additional information about thread termination, see Section 15.7.8.4, “KILL Statement”, in particular for the instructions about killed REPAIR TABLE or OPTIMIZE TABLE operations on MyISAM tables. If a thread is updating a nontransactional ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/8.4/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If so, the routine uses the variable value without reading the ...If ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on ...For example, rows can be inserted by INSERT or LOAD DATA statements, and an insert trigger activates for each inserted ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. For information about account representation in the user table, see Section 8.2.3, “Grant Tables”. Warning The MySQL user name length limit is hardcoded in MySQL servers and ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
For example, you can view the algorithm used to train the model, the columns in the training table, and values for the model explanation. When you run the ML_MODEL_IMPORT routine, the imported table has a model_metadata column that stores the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-explanations.html
Generating Prediction Explanations for a Table After training a model, you can generate a table of prediction explanations on the house_price_testing dataset by using the default Permutation Importance prediction explainer. To generate explanations ... After training a regression model, you can query the default model explanation or query new model ...