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/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system ...A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Whether the workload is more like a data warehouse (primarily queries) or an OLTP system (mix of queries and DML). Data Characteristics and Compression A key determinant of the efficiency of compression in reducing the size of data files is the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
row *************************** id: 1 select_type: PRIMARY table: t1 type: index possible_keys: NULL key: PRIMARY key_len: 4 ref: NULL rows: 4 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 2 ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
In this case, as we can see from the EXPLAIN output, it uses the table's primary key. row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The REQUIRE_TABLE_PRIMARY_KEY_CHECK option (available from MySQL 8.0.20) makes the replication channel use its own policy for primary key checks. Setting ON means that primary keys are always required, and setting OFF means that primary keys are ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
Also, the physical page size of the compressed table (KEY_BLOCK_SIZE) must be equal to FILE_BLOCK_SIZE/1024. For example, if innodb_page_size=16KB and FILE_BLOCK_SIZE=8K, the KEY_BLOCK_SIZE of the table must be 8. To determine a valid KEY_BLOCK_SIZE ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
CREATE TABLE t1 (c1 INT PRIMARY KEY) DATA DIRECTORY = '/external/directory'; The DATA DIRECTORY clause is supported for tables created in file-per-table tablespaces. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
In order of occurrence, ALTER TABLE stage events include: stage/innodb/alter table (read PK and internal sort): This stage is active when ALTER TABLE is in the reading-primary-key phase. It starts with WORK_COMPLETED=0 and WORK_ESTIMATED set to the ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...