Search Results
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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-an-anomaly-detection-model.html
Requirements for Anomaly Detection Training Consider the following based on the type of anomaly detection you are running: Set the task parameter to anomaly_detection for running anomaly detection on table data, or log_anomaly_detection for running ... After preparing the data for an anomaly detection model, you can train the ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-named-windows.html
Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-intro-advisor-page-ref.html
Figure 19.1 Manage Advisors Page The components and controls of the Manage Advisors page are as follows: Table 19.1 Manage Advisors Page Controls Name Description Edit Selected Opens the edit dialog for the selected advisor. Memory Usage: Indicate ...To display the Advisors page, select Advisors from the Configuration ...