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/rename-table.html
Regardless of the statement used, if the rename operation would move the table to a database located on a different file system, the success of the outcome is platform specific and depends on the underlying operating system calls used to move table ...You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new ...As of MySQL 8.0.13, you can rename tables locked with a LOCK TABLES statement, provided that they are locked with a ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. During the checksum operation, the table is locked with a read lock ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 franchises as shown in the following table. You can cause this type of error to be ignored by ...As in partitioning by RANGE, each partition must be explicitly ... List ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-start-phases.html
The cluster starts with a clean file system on all data nodes. Initialization consists of the following steps: Obtain a node ID Fetch configuration data Allocate ports to be used for inter-node communications Allocate memory according to settings ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. You can refer to tables from different databases in the same statement. The maximum index width for InnoDB tables is either 767 bytes or 3072 bytes. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memoryusage.html
Suppose that the cluster has 2 data nodes having node IDs 5 and 6, and the config.ini file contains the following: [ndbd default] DataMemory = 1G IndexMemory = 1G Suppose also that the value of the LongMessageBuffer configuration parameter is ...The ... Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. This includes any default value implied for this option by the setting of the InitialLogFileGroup data node ...For ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement creates a new log file group named logfile_group having a single UNDO file named ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
All members of the group must use the same communication protocol version, so that group members can be at different MySQL Server releases but only send messages that can be understood by all group members. Members with different communication ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
AND key_partN = constN Any range condition over the primary key of an InnoDB table. If one of the merged conditions is a condition over the primary key of an InnoDB table, it is not used for row retrieval, but is used to filter out rows retrieved ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Rows updated to values that would cause data conversion errors are updated to the closest valid values instead. If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the ...With the IGNORE modifier, the update statement does not abort even if errors occur during the ...An UPDATE ...