Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-classification-generate-explanation.html
Generating Prediction Explanations for a Table After training a model, you can generate a table of prediction explanations on the testing_data dataset by using the default Permutation Importance prediction explainer. To generate explanations for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-metrics.html
If the input table overlaps with the training table, and remove_seen is true, which is the default setting, then the model will not repeat a recommendation and it ignores the overlap items. The precision_at_k value for the input table is the average ... The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric ...
https://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html
Alternatively, you can run the same validation tests from the Validate tab within the panel as the following figure shows. In addition, the output is organized by category: Validating routine groups, Validating routines, Validating tables, and ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
In addition, some DDL statements issue interim transaction commits: for example, ALTER TABLE issues a commit after data is copied from the original table to the internal temporary table. DDL statements use a form of "semantic" logging to maintain ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
For upgrades, a check box enables you to skip the upgrade check and process for system tables, while checking and processing data dictionary tables normally. This behavior represents a change in how MySQL Server performs an upgrade (see What the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-configuration-views-ref.html
DDL Statements: filters on statements of type CREATE, DROP, ALTER, TRUNCATE, and RENAME. Statements with Full Table Scans: filters on the advanced filter options of Table Scan notices and Total Table Scans > 0. Statements with Temporary Tables: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
Operations involving ALTER TABLE such as loading, unloading, or recovering data when MySQL Server is running in SUPER_READ_ONLY mode. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If a session has open temporary tables, the replication format cannot be changed for the session (SET @@SESSION.binlog_format). If any ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If you did not make a deliberate decision about the storage engine, and you want to preview how certain tables work when created using InnoDB, issue the command ALTER TABLE table_name ENGINE=InnoDB; for each table. Alternatively, to run test queries ...Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, editing, and querying features ... If InnoDB is not the default storage ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...