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/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. Changing a column's blob part size must be done using a copying ALTER TABLE; this operation cannot be ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To free up the memory used by deleted rows, use ALTER TABLE ENGINE=MEMORY to force a table rebuild. The MEMORY storage ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished using the ALTER TABLE statement with the DROP PARTITION option. To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr ...For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY ... Adding and dropping of ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
If an ALTER TABLE operation runs out of space, it starts a rollback, and that can take hours if it is disk-bound. Declare the PRIMARY KEY clause in the original CREATE TABLE statement, rather than adding it later through an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their implementation. CREATE TABLE and ALTER TABLE statements that would result ...Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE. InnoDB Details For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE ... OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
While a --single-transaction dump is in process, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
An alternative to a MERGE table is a partitioned table, which stores partitions of a single table in separate files and enables some operations to be performed more efficiently. Use ALTER TABLE tbl_name UNION=(...) to change the list of underlying ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...