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/if.html
The IF statement can have THEN, ELSE, and ELSEIF clauses, and it is terminated with END IF. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
UNLOCK TABLES commits a transaction only if any tables currently have been locked with LOCK TABLES to acquire nontransactional table locks. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in ...
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 ...