Search Results
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/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-ai/9.5/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.5/en/mys-ai-aml-scoring-a-recommendation-model.html
Set a positive integer between 1 and the number of rows in the table. remove_seen: If the input table overlaps with the training table, and remove_seen is true, then the model will not repeat existing interactions. Set remove_seen to false to repeat ... After generating predicted ratings/rankings and recommendations, you can score the model to assess its ...
https://dev.mysql.com/doc/mysql-ai/9.5/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.5/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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. If you attempt to load a table without at least one column with the VECTOR data type, an error occurs. LOAD DATA with ALGORITHM=BULK has the following ...It does not support automatic rounding or truncation of the input ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-export.html
Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined table. ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY ...To ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MySQL ...The available referential actions are RESTRICT, CASCADE, SET NULL, and NO ACTION (the ...