Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not found, the statement fails with an error (partition 'partition_name' doesn't exist). Explicit ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
SERVICE_STATE ON (thread exists and is active or idle) or OFF (thread no longer exists). For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
SERVICE_STATE ON (thread exists and is active or idle) or OFF (thread no longer exists). This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, data ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. To affect existing threads, modify the INSTRUMENTED and HISTORY columns of threads table rows. The setup_actors ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. To affect existing threads, modify the INSTRUMENTED and HISTORY columns of threads table rows. The threads table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
When the Performance Schema initializes, it populates the threads table based on the threads in existence then. To control these aspects of existing threads, set the INSTRUMENTED and HISTORY columns of threads table rows. The threads table contains ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
For example, if the plugin implements a storage engine, existing tables for the storage engine become inaccessible, and attempts to create new tables for the storage engine result in tables that use the default storage engine unless the ... Server ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
If you have updated an existing MySQL installation to a newer version, did you perform the MySQL upgrade procedure? If not, do so. Reloading the grant tables affects new client connections, but it also affects existing connections as indicated in ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
When modifying an existing table that is not partitioned to accommodate partitioning, or, when modifying the partitioning of an already partitioned table, you may consider altering the table's primary key (see Section 26.6.1, “Partitioning Keys, ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...