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/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. When viewed in terms of events, the process of checking table options is the same for both row-based ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 19.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create the indexes even faster by turning them off with ALTER TABLE ... DISABLE KEYS before ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
If you wish to make such information hidden from queries that select from these tables, you can do so by setting the value of the show_gipk_in_create_table_and_information_schema server system variable to OFF. INFORMATION_SCHEMA provides access to ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. The threads table contains a ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Online DDL improves several aspects of MySQL operation: ...Reduced ...
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 ...The storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
Creating a New Table and Column Mapping This example shows how to setup your own InnoDB table with the daemon_memcached plugin. mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
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 ...