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/partitioning-list.html
As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 franchises as shown in the following table. You can cause this type of error to be ignored by ...As in partitioning by RANGE, each partition must be explicitly ... List ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. With respect to the previous examples, the ''@'localhost' and 'user2'@'%.example.com' accounts should be changed not to use ...When a client connects successfully, the server authenticates the client to a particular row in this ...Specifically, do not permit User to be empty (which ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
(However, to fully protect system accounts against regular accounts, you must also withhold modification privileges for the mysql system schema from regular accounts. To kill a session or statement that is executing with the SYSTEM_USER privilege, ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/declare.html
END compound statement and must be at its start, before any other statements. The DECLARE statement is used to define various items local to a program: Local variables. Variable and condition declarations must appear before cursor or handler ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For BETWEEN and IN(), only the first argument can be replaced by a matching generated column, and the other arguments must have the same result type. The generated column must be defined as an expression that contains at least a function call or one ...For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-upgrade.html
Note that if you require the primary to remain the same throughout (except when it is being upgraded itself), you must first upgrade all of the secondaries to a version higher than or equal to the target primary member version, then upgrade the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
The setting for group_replication_communication_max_message_size must be less than replica_max_allowed_packet (or slave_max_allowed_packet), because the applier thread cannot handle message fragments larger than the maximum permitted packet size. As ... When an abnormally large message is sent between Group Replication group members, it can result in some group members being reported as failed and expelled from the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
Also, if you are using caching SHA-2 authentication, you must set up RSA key-pairs on the group members. Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members ...For ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
The delta is calculated between the reference table specified by in_table and the snapshot, which must exist. This view must be specified using the statement_performance_analyzer.view configuration option to name a query or an existing view. If ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. For example, the following does not work: SELECT * FROM temp_table ...