Search Results
https://dev.mysql.com/doc/refman/9.7/en/faqs-mysql-cluster.html
See Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. In ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
Even when the Performance Schema is disabled, it continues to populate the global_variables, session_variables, global_status, and session_status tables. This occurs as necessary to permit the results for the SHOW VARIABLES and SHOW STATUS ...The ...
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/refman/9.7/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/9.7/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/refman/9.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/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. As with table partitioned by RANGE, ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...