PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. Figure 17.12 State Transfer: Catching Up As view ... This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming transactions from the ...
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. The primary key value for a row is duplicated in all the secondary index records that point to the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
https://dev.mysql.com/doc/refman/5.7/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). The thread is aborted the next time it checks the ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Creating a table with these columns with an explicit ROW_FORMAT clause does not raise an error or warning; the format specification is ignored. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
To obtain global and per-session statement execution counts, use the events_statements_summary_global_by_event_name and events_statements_summary_by_thread_by_event_name tables, respectively. If the performance_schema_max_thread_instances system ...