Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. This means that MySQL reads a row from the first table, then ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
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/mysql-cluster-online-operations.html
MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... 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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Dictionary::createIndex() Description This method creates an index given an instance of Index and possibly an optional instance of Table. Signature This method can be invoked with or without a reference to a table object: int createIndex ( const ...
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/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym ...Note It is not possible to issue FLUSH statements within stored functions or ...
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-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. The Version column in the output contains the table's schema object version. Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...