Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. altering table The server ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
(It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] System Variable ndb_allow_copying_alter_table Scope ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. This topic contains the following ...Note the following points about the ENGINE_ATTRIBUTE option: Ensure that the ENGINE_ATTRIBUTE option specifies all the files to be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration Parameters). (NDB 8.4.0) This global parameter can be set only in the [ndbd default] section, and ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
To create an NdbInterpretedCode object, invoke the constructor, optionally supplying a table for the program to operate on, and a buffer for program storage and finalization. If no table is supplied, then only instructions which do not access table ... This section provides information about the NdbInterpretedCode class, which can be used to prepare and execute an NDB API interpreted ...