Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users having SUPER privilege and only if function created does not break binary logging. report_password: Arbitrary ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user connection. For example, if parallel transactions affect index creation or an online buffer pool resizing operation, ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-configuration.html
Create a suitable user account on all the sources that the replica can use to connect. If you create an account solely for the purposes of replication, that account needs only the REPLICATION SLAVE privilege. You can use the same account on all the ... A multi-source replication topology requires at least two sources and one replica ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. Online operations are noncopying; that is, they do ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
As an example, if we have a group with 3 members and we send a 100 bytes message, this value will account for 300 bytes, since we send 100 bytes to each node. restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or ...
https://dev.mysql.com/doc/workbench/en/wb-plugins.html
Plugins are special Modules that are exposed to the user through the Workbench GUI. A plugin can be a simple function that performs some action on an input, and ends without further interaction with the user. To create a simple plugin, the function ...This is typically done using the main menu, or the context-sensitive ...