PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
We can verify this behavior by examining the effects on the file system of creating a table partitioned by HASH and populating it with a record containing appropriate values. Partitioning in MySQL does nothing to disallow NULL as the value of a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
For more information about permitted partitioning column types and partitioning functions, see Section 26.2, “Partitioning Types”, as well as Section 15.1.20, “CREATE TABLE Statement”, which provides partitioning syntax descriptions and ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
The process of creating the replication user for distributed recovery can be captured in the binary log, and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
There are six columns, three of which are hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, and BLOB and TEXT types) fully off-page, with the clustered index record containing only a 20-byte pointer to the overflow ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...