PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. For in-place operations, the ability to adjust the balance between performance and concurrency during DDL operations using the LOCK clause. Less ...Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html
...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
The files created by the backup on each data node are listed here, where N is the node ID and B is the backup ID. BACKUP-B-0.N.Data BACKUP-B.N.ctl BACKUP-B.N.log These files are found under BackupDataDir/BACKUP/BACKUP-B, on each data node. Have all ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
Otherwise, the following error is returned: ERROR 3846 (HY000): Redo log archive directory 'directory_path1' is accessible to all OS users Directories cannot be those defined by datadir, innodb_data_home_dir, innodb_directories, ...Redo log files ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Assuming the above exceptions do not apply to your database, use the cold backup technique to obtain a reliable binary snapshot of InnoDB tables: do a slow shutdown of the MySQL Server, then copy the data files manually. For InnoDB, all tables in ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
If removal of the database directory fails due to a file system error or server halt, the DROP DATABASE transaction is not rolled back. Flushing the redo logs immediately avoids situations where data files are modified by DDL operations but the redo ...However, removal of the database directory from the file system occurs last and is not part of the atomic ...An atomic DDL statement combines the data dictionary updates, ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
For multi-file tablespaces, specify each file: ibd2sdi ibdata1 ibdata2 The files of a multi-file tablespace must be specified in order of the ascending page number. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general ...It ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
Because there are considerable differences in how InnoDB and NDB treat data files, the two storage engines are covered separately in the discussion that follows. An InnoDB tablespace supports only a single data file, whose name must include a .ibd ...One data file is created and added to the tablespace using this ...The UNDO keyword, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbmtd.html
Trace files are generated by critical errors in ndbmtd processes in a somewhat different fashion from how these are generated by ndbd failures. Like ndbd, ndbmtd generates a set of log files which are placed in the directory specified by DataDir in ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...Using ndbmtd differs from using ndbd in two key ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... The redistribution for NDBCLUSTER tables ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...