PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/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/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/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/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
row *************************** ENGINE: INNODB REQUESTING_ENGINE_LOCK_ID: 140211201964816:2:4:2:140211086465800 REQUESTING_ENGINE_TRANSACTION_ID: 1555 REQUESTING_THREAD_ID: 47 REQUESTING_EVENT_ID: 5 REQUESTING_OBJECT_INSTANCE_BEGIN: 140211086465800 ... The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and ...For ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. For floating-point and fixed-point data types, M is the total number of digits that can be stored. As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; ...Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type ...