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/thread-pool-installation.html
Thread Pool Installation as of MySQL 8.0.14 Thread Pool Installation Prior to MySQL 8.0.14 Thread Pool Installation as of MySQL 8.0.14 In MySQL 8.0.14 and higher, the thread pool monitoring tables are Performance Schema tables that are loaded and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
In the sections that follow, we do not necessarily provide all possible forms for the syntax that can be used for creating each partition type; for this information, see Section 15.1.20, “CREATE TABLE Statement”. With this type of partitioning, ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. To update table index statistics for best estimates, use ANALYZE TABLE. In MySQL 8.0, index dive skipping ...The following sections describe conditions under which the optimizer uses range ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 767 bytes long for InnoDB tables that use the REDUNDANT or COMPACT row format. Note Prefix limits are measured in bytes, whereas the prefix length in CREATE ...The maximum number of indexes per table and the maximum index length is defined per storage ... The most common type of index involves a single column, storing copies of the values from that ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...Within statements considered for rewrite, instances of the following clauses are rewritten and each instance replaced by a single space: ENCRYPTION DATA DIRECTORY (at the table and partition levels) INDEX DIRECTORY (at the table and partition levels) Rewriting does not depend on ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin authentication_fido_client Library file authentication_fido.so, authentication_fido_client.so ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...