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/replication-asynchronous-connection-failover-replica.html
When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. To configure this feature, the replication ... In ...Ensure that SOURCE_RETRY_COUNT and SOURCE_CONNECT_RETRY are set to minimal numbers that just allow a few retry attempts, for example 3 and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
Even though it is permitted to use NULL as the value of an expression that must otherwise yield an integer, it is important to keep in mind that NULL is not a number. We can verify this behavior by examining the effects on the file system of ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-doxygen.html
Next, generate the doxygen documentation: $> make doxygen Inspect the error log, which is available in the doxyerror.log file in the top-level directory. When you install PlantUML on Windows (tested on Windows 10), you must run it at least once as ... The MySQL source code contains internal documentation written using ...
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 ...
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 ...