Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
On server2, extract that statement from the mysqldump output, and store the GTID set into a local variable, such as $gtid_purged_set. To check, on server1, extract and store gtid_purged from the output into a local variable as done previously, then ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed table. Whenever the binary log is rotated or the server is ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
The following subqueries are transformed into antijoins: NOT IN (SELECT ... IN (SELECT ...)) IS NOT TRUE can be transformed into antijoins. Materialize the subquery into an indexed temporary table that is used to perform a join, where the index is ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
(Even if a view is updatable, it might not be possible to insert into it, as described elsewhere in this section.) The updatability of views may be affected by the value of the updatable_views_with_limit system variable. For a multiple-table ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
The import status and its effects on newcluster and its cluster processes persist until we have completed importing another cluster into newcluster. After the successful dry run, you are now ready to import the wild cluster's configuration into ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. You can check from your C applications whether a value was stored in an ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store. While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-train-test-split.html
The TRAIN_TEST_SPLIT routine automatically splits your data into training and testing datasets. For each class in the dataset, 80% of the samples goes into the training dataset, and the remaining goes into the testing dataset. The first 80% of the ...Two new tables in the same database are created with the following names: [original_table_name]_train [original_table_name]_test The split of the data between training and testing datasets depends on the machine learning ...