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/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-basics.html
You must be careful that node IDs for any new data nodes added in the config.ini file do not overlap node IDs used by existing nodes. Assuming that you already have a running NDB Cluster, adding data nodes online requires the following steps: Edit ... In this section, we list the basic steps required to add new data nodes to an NDB ...For a more detailed ...This causes any API ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. When the server later must read a JSON value stored in this binary format, the value ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. The relay log files must be backed up separately if they have ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. The .txt file contains the table data, one line per table row. The following command dumps the ...If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each ...
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/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA DIRECTORY = '/external/directory'; This ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File '/path/to/tablespace_name.ibd' already exists. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. The following ...mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning ...For ...