PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. Statement-based replication depends on ...If you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
The database that is checked for a match depends on the binary log format of the statement that is being handled. The statement is not executed until all table-level options (if any) have also been checked, and the outcome of that process permits ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-member-actions.html
By default, super read-only mode is disabled on the primary when it is elected, so that the primary becomes read-write, and accepts updates from a replication source server and from clients. The member actions configuration, consisting of all the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-server-states.html
If the group is fully functional and all members are communicating properly, all members report the same state for all other members. In this situation, the member does not attempt to guess the status of the other servers, and instead reports them ... The state of a Group Replication group member shows its current role in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html
Database page content is not written to the doublewrite buffer, and recovery does not use the doublewrite buffer to fix incomplete page writes. MySQL 8.0.30 onwards supports dynamic changes to the innodb_doublewrite setting that enables the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html
InnoDB monitor output begins with a header containing a timestamp and the monitor name. The --innodb-status-file option is intended for temporary use, as output generation can affect performance, and the innodb_status.pid file can become quite large ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using mysqld_safe. It can be used on systems such as Linux and Solaris that use System V-style run directories to start and stop ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
If synchronization of the object fails due to a temporary error, it is picked up and added back to the queue (and to this table) the next time NDB performs mismatch detection; if the attempts fails due a permanent error, the object is added to the ...Table 29.3 Performance Schema NDB Tables Table Name Description ndb_sync_excluded_objects NDB objects which cannot be synchronized ndb_sync_pending_objects NDB objects waiting for synchronization Beginning with NDB 8.0.16, automatic synchronization in NDB attempts to detect and synchronize automatically all mismatches in metadata between the NDB Cluster's internal dictionary and the MySQL Server's ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. If a statement that executed a long time ago took a lock but ...The relation is based on a nested set data model, so the join has several ...