PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
COLUMN_KEY Whether the column is indexed: If COLUMN_KEY is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. If COLUMN_KEY is PRI, the column is a PRIMARY KEY or is one of the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-fields-table.html
The INNODB_SYS_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary. The INNODB_SYS_FIELDS table has these columns: INDEX_ID An ...For ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/load-index.html
tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ... | ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key ...LOAD INDEX INTO CACHE applies only to MyISAM tables, including partitioned MyISAM ...
https://dev.mysql.com/doc/refman/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
It calculates a checksum for all key values in the rows and verifies that the checksum matches the checksum for the keys in the index tree. It does a check-read of every key for each row to verify that they indeed point to the correct row. To check ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-optimization.html
OPTIMIZE TABLE does a table repair and a key analysis, and also sorts the index tree so that key lookups are faster. myisamchk has a number of other options that you can use to improve the performance of a table: --analyze or -a: Perform key ... To ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. If the file size would be larger than this value, the index is created using the key cache instead, which is slower. If the repair ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
The information written to the file includes the table key and BLOB part number for each orphaned BLOB part. This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--query=# Command-Line Format --query=# Type Numeric Default Value 0 Minimum Value 0 Maximum Value MAX_INT Perform random range queries on first key attribute (must be int unsigned). ndb_index_stat provides per-fragment statistical information ...