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/index-btree-hash.html
Hash Index Characteristics Hash indexes have somewhat different characteristics from those just discussed: They are used only for equality comparisons that use the = or <=> operators (but are very fast). Understanding the B-tree and hash data ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
The second part (lastname LIKE '%etrunia%') cannot be used to limit the number of rows that must be scanned, so without Index Condition Pushdown, this query must retrieve full table rows for all people who have zipcode='95054'. Index Condition ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If this merge-split behavior occurs frequently, it can have an adverse affect on performance. If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-statistics-table.html
You can see information only for columns for which you have some privilege. The COLUMN_STATISTICS table provides access to histogram statistics for column values. For information about histogram statistics, see Section 10.9.6, “Optimizer ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
The table contains rows only for accounts that have had one or more consecutive failed connection attempts without a subsequent successful attempt. This table provides information about the current number of consecutive failed connection attempts ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
SELECT tables.NAME AS table_name, indexes.NAME AS index_name, cached.N_CACHED_PAGES AS n_cached_pages FROM INFORMATION_SCHEMA.INNODB_CACHED_INDEXES AS cached, INFORMATION_SCHEMA.INNODB_INDEXES AS indexes, INFORMATION_SCHEMA.INNODB_TABLES AS tables ... The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
row *************************** SPACE: 57 PATH: ./test/t1.ibd Notes You must have the PROCESS privilege to query this table. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
row *************************** INDEX_ID: 117 NAME: col1 POS: 0 Notes You must have the PROCESS privilege to query this table. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-cols-table.html
row *************************** ID: test/fk1 FOR_COL_NAME: parent_id REF_COL_NAME: id POS: 0 Notes You must have the PROCESS privilege to query this table. The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
row *************************** ID: test/fk1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 Notes You must have the PROCESS privilege to query this table. For related usage information and examples, see Section 17.15.3, “InnoDB ...