Search Results
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
For example, you may as well have a primary key since otherwise InnoDB will make one anyway. And that primary key should be the shortest of the candidate keys, since InnoDB will use it as a pointer if there are secondary indexes. Finally: InnoDB's ... The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
Use application-specific logic on the master that ensures that rows inserted are unique in the key's columns. Note: There are no restrictions on extra keys on the master. In addition to what we guarantee in (P-rpl-correct), we also guarantee ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationreplica-category.html
Source Ssl Key The name of the SSL key file to use for establishing a secure connection to the replica's source. Rows Search Algorithms When preparing batches of rows for row-based logging and replication using replica_allow_batching, this option ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv') STRICT_LOAD = 0; VERIFY_KEY_CONSTRAINTS: Lakehouse validates primary key and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The specified input table must already exist, must not be empty, and must have a ... The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. The specified input table must already exist, must not be empty, and must have a ... The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Advanced options: Tables without primary key: Specify how a replication channel handles the creation and alteration of tables with no primary keys on the source. Raise an error : Raise an error when replicating a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/administrative-connection-interface.html
When clients connect to the administrative interface, they should use the same certificate and key files as for ordinary connections on the main interface. When clients connect to the administrative interface, they should use certificate and key ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
mysql> SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES; Plugins that are active on the donor, including any keyring plugin, must also be active on the recipient. To configure the recipient MySQL server instance to use an encrypted connection: Make ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
This would be the case, for example, were custid a primary key of customers. For example, if name is a primary key, its value determines the value of address because each group has only one value of the primary key and thus only one row. The query ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...