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/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/8.0/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
The error summary tables have these indexes: events_errors_summary_by_account_by_error: Primary key on (USER, HOST, ERROR_NUMBER) events_errors_summary_by_host_by_error: Primary key on (HOST, ERROR_NUMBER) events_errors_summary_by_thread_by_error: ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
The memory summary tables have these indexes: memory_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) memory_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) memory_summary_by_thread_by_event_name: Primary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-summary-tables.html
The stage summary tables have these indexes: events_stages_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_stages_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance Schema maintains ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
The transaction summary tables have these indexes: events_transactions_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_transactions_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
mysql> CREATE TABLE opening_lines ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200) ) ENGINE=InnoDB; If you choose to define the FTS_DOC_ID column yourself, you are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
This is subject to the following limitations: Only the KEY and LINEAR KEY partitioning schemes are supported in production with NDB tables. This section discusses the manner in which NDB Cluster divides and duplicates data for storage. A number of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
The threads table has these indexes: Primary key on (THREAD_ID) Index on (NAME) Index on (PROCESSLIST_ID) Index on (PROCESSLIST_USER, PROCESSLIST_HOST) Index on (PROCESSLIST_HOST) Index on (THREAD_OS_ID) Index on (RESOURCE_GROUP) TRUNCATE TABLE is ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since NDB does not use single-key access for ordered indexes, the counts for tot_key_reads, tot_key_inserts, tot_key_updates, tot_key_writes, and tot_key_deletes are not incremented by ordered index operations. Note When using tot_key_writes, you ...