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/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
Some MySQL storage engines, including InnoDB, do not support per-partition optimization; in these cases, ALTER TABLE ... A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
See Section 26.3.5, “Obtaining Information About Partitions”, for a discussion of mechanisms provided in MySQL 8.0 for obtaining information about partitioned tables and partitions. There are a number of ways using SQL statements to modify ...
https://dev.mysql.com/doc/refman/8.0/en/password-security.html
The following sections provide guidelines that enable end users and administrators to keep these passwords secure and avoid exposing them. In addition, the validate_password plugin can be used to enforce a policy on acceptable password.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-innodb-redo-log-files-table.html
The innodb_redo_log_files table contains a row for each active InnoDB redo log file. The innodb_redo_log_files table has the following columns: FILE_ID The ID of the redo log file. FILE_NAME The path and file name of the redo log file. START_LSN ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-communication-information-table.html
This is set to accommodate the oldest MySQL Server version that you want the group to support. This table shows group configuration options for the whole replication group. The replication_group_communication_information table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...