Search Results
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
[into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY [ {col_name | expr | position}, ... } export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. They are actually views, not base tables, so there are no files ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... A table reference (when it refers ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
For information about MySQL Enterprise Firewall Information Schema and Performance Schema tables, see Section 28.7, “INFORMATION_SCHEMA MySQL Enterprise Firewall Tables”, and Section 29.12.17, “Performance Schema Firewall Tables”, ...When ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. An exclusive metadata lock on the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. In other words, every unique key on the table must ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
To cause indexes to be ignored when restoring the table data, use the --disable-indexes option. When the --epoch option (short form: -e) is used, epoch information is restored to the cluster replication status table (mysql.ndb_apply_status), which ...Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file systems to be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table. Event-based incremental load automates the process of updating external tables based on changes ... As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking ...