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-gtids.html
The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group members. All the transactions received directly by the group can therefore be identified and are grouped together in GTID sets, and it does not matter which member ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, decrypt, and output information about files created by NDB Cluster that are compressed, encrypted, or both. Options --compress, -c Command-Line Format --compress Introduced ...This is similar to entering a password after invoking mysql --password with no password following the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog and mysql to restore the changes that occurred after the backup was made. If all changes are flushed from the buffer pool to the tablespaces ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, ...For ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
The query sees the changes made by transactions that committed before that point in time, and no changes made by later or uncommitted transactions. A consistent read does not set any locks on the tables it accesses, and therefore other sessions are ... A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in ...
https://dev.mysql.com/doc/refman/8.0/en/log-file-maintenance.html
When using MySQL with logging enabled, you may want to back up and remove old log files from time to time and tell MySQL to start logging to new files. To rename the general query log or slow query log at runtime, first connect to the server and ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
row *************************** Id: 1 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show processlist *************************** 2. row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL ...When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
When the joining member is up to date with all the group's transactions, it is declared online and can participate in the group as a normal member, and distributed recovery is complete. This minimizes the time taken for distributed recovery, and ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
The following list shows the CHANGE REPLICATION FILTER options and how they relate to --replicate-* server options: REPLICATE_DO_DB: Include updates based on database name. Filters set using this statement differ from those set using the server ...