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-shm-definition.html
In setups where multiple hosts are each running a data node and an API node, it is possible to enable shared memory on all such hosts by setting UseShm in the [ndbd default] section of the configuration file. The API nodes for which no host names ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-rpm.html
The name of this file follows the pattern shown here: mysql-cluster-license-ver-rev.distro.arch.rpm-bundle.tar You can extract the individual RPM files from this file using tar or your preferred tool for extracting archives. The components required ... This section covers the steps necessary to install the correct executables for each type of NDB Cluster 8.0 node using RPM packages supplied by ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
As of MySQL 8.0.21, if the tablespace was created with an earlier version and resides in an unknown directory, InnoDB creates the new tablespace in the default location and writes the following warning to the error log: The DATA DIRECTORY location ...The usual result is “0 rows affected,” which should be interpreted as “no information.” As long as the table definition is valid, the table can be re-created as an empty table with TRUNCATE TABLE, even if the data or index files have become ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not found, the statement fails with an error (partition 'partition_name' doesn't exist). Partition ... Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
To determine whether your system supports symbolic links, check the value of the have_symlink system variable using this statement: SHOW VARIABLES LIKE 'have_symlink'; The handling of symbolic links for MyISAM tables works as follows: In the data ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
The InnoDB buffer pool is a memory area that holds cached InnoDB data for tables, indexes, and other auxiliary buffers. For each MyISAM table the server opens, the index file is opened once; the data file is opened once for each concurrently running ...For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache, using a variation of the LRU ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ...The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review Backing Up a Database ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
The server where the snapshot is taken can be either the source or one of its replicas, but you must ensure that the server has processed all required transactions before copying the data. There are several variants of this method, the difference ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. Some ...Keys and indexes on NDB Cluster tables are subject to the following limitations: Column ...Attempting to create an index on an NDB table column whose width is greater than 3072 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For object definitions that refer to the utf8mb4 character set, you can dump them with mysqldump prior to downgrading, edit the dump file to change instances of utf8mb4 to utf8, and reload the file in the older server, as long as there are no 4-byte ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...Note This discussion focuses primarily on converting between utf8mb3 ...