Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
Modifications that did not finish updating data files before an unexpected shutdown are replayed automatically during initialization and before connections are accepted. Otherwise, an error similar to the following is returned: ERROR 3845 (HY000): ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
InnoDB page size is defined by the innodb_page_size variable, which is configured when initializing a MySQL server instance. To determine if the source table was defined with a DATA DIRECTORY clause, use SHOW CREATE TABLE to view the table ... This ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
The pool of temporary tablespaces is removed on normal shutdown or on an aborted initialization. The global temporary tablespace is removed on normal shutdown or on an aborted initialization, and recreated each time the server is started. row ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
For example, use these lines in the server my.cnf file, adjusting the .so suffix and file locations for your platform as necessary: [mysqld] early-plugin-load=keyring_aws.so ... Note The keyring_aws plugin is an extension included in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-computer-definition.html
Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the cluster. The [computer] section has no real significance other than serving as a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-file.html
When --initial is used, the global configuration file is re-read, any existing cache files are deleted, and the management server creates a new configuration cache. For more information about the --configdir, --config-cache, --initial, and --reload ... Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
This log file group is to be made up of two undo log files, which we name undo_1.log and undo_2.log, whose initial sizes are 16 MB and 12 MB, respectively. (The default initial size for an undo log file is 128 MB.) Optionally, you can also specify a ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...