Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...This can be nonzero if the value of performance_schema_digests_size is too ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...These statements are written to the binary log unless you specify NO_WRITE_TO_BINLOG or its alias ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. See Section 10.4.7, “Limits on Table Column Count and Row Size”. Trailing spaces are automatically deleted from ENUM and ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
If a stored program that modifies data is nondeterministic, it is not repeatable. Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. If a function ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. It prefers MERGE over TEMPTABLE if possible, because MERGE is usually more efficient and because a view cannot be updated if ... The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/monitoring-innodb-cluster.html
memberRole the Member Role as reported by the Group Replication plugin, see the MEMBER_ROLE column of the replication_group_members table. This value is taken from the VIEW_ID column of the replication_group_member_stats table. Note This is only ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-items-to-users.html
Set remove_seen to false to repeat existing interactions from the training table. Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a ... This ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-users-to-items.html
Set remove_seen to false to repeat existing interactions from the training table. Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a ... This ...