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/group-replication-connection-security.html
The group_replication_ssl_mode system variable must be set to the required setting for group communications. If group_replication_ssl_mode is set to REQUIRED, VERIFY_CA, or VERIFY_IDENTITY, use --ssl and require_secure_transport=ON. This privilege ... From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html
Enable the stage/innodb/clone% instruments: mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME LIKE 'stage/innodb/clone%'; Enable the stage event consumer tables, which include events_stages_current, ...You can monitor ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To update the tables to the expected structure, perform the MySQL upgrade procedure. To manage MySQL accounts, use ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
Is it possible for a trigger to update tables on a remote server? A.5.12. Does MySQL have statement-level or row-level triggers? All triggers are FOR EACH ROW; that is, the trigger is activated for each row that is inserted, updated, or deleted. For ...Where can I find the documentation for MySQL 8.0 triggers? ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
Table statistics are updated only for DELETE or UPDATE operations that modify indexed columns. Statistics are not updated by operations that modify only nonindexed columns. MODIFIED_COUNTER The number of rows modified by DML operations, such as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. If you can afford to permit a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) and the local query handler (LQH), and written to the cluster log. This includes all inserts, updates, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-general.html
Important If you attempt to use NDB Cluster Replication with --binlog-format=STATEMENT, replication fails to work properly because the ndb_binlog_index table on the source cluster and the epoch column of the ndb_apply_status table on the replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-multi-source.html
All SQL nodes acting as sources and replicas are started with the system variable log_replica_updates (beginning with NDB 8.0.26) or log_slave_updates (NDB 8.0.26 and earlier) enabled. You must not start any of the SQL nodes with the system variable ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG ' ... The following examples ...