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/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). SQL_MODE The SQL mode in effect when the trigger was created, and under which the trigger executes. To see information about a table's triggers, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
The directory should have a restrictive mode and be accessible only to the account used to run the MySQL server. Before updating the file, the plugin verifies that it contains the expected checksum. Note The keyring_aws plugin is an extension ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-top.html
These two display modes provide the same information; they can be used concurrently. The display updates once per second; to set a different delay interval, use --sleep-time (-s). The next figure shows ndb_top running in a terminal window on a Linux ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
When reading data with LOAD DATA, empty or missing columns are updated with ''. Under certain conditions, if you insert NULL into a TIMESTAMP column, the current date and time is inserted; this behavior depends in part on the server SQL mode (see ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For a replication connection, specifying a value for either of SOURCE_SSL_CA or SOURCE_SSL_CAPATH corresponds to setting --ssl-mode=VERIFY_CA. For a replication connection, specifying MASTER_SSL_VERIFY_SERVER_CERT=1 corresponds to setting ... To use ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of nonspace characters, you can cause an error to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
From MySQL 8.0.27, the group communication engine can use a single leader to drive consensus when the group is in single-primary mode. Operating with a single consensus leader improves performance and resilience in single-primary mode, particularly ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...