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/memory-storage-engine.html
Performance Characteristics MEMORY performance is constrained by contention resulting from single-thread execution and table lock overhead when processing updates. In particular, the table locking involved with performing updates can slow down ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. A free block can occur as a result of deleting rows or an update of a dynamic length row with more data than its current contents. myisamchk marks tables as ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
Updates received from A must be logged by B to its binary log, in order to be passed on to C. In addition to binary logging, this replication topology requires the system variable log_replica_updates (from MySQL 8.0.26) or log_slave_updates (before ... Each replica must have a unique server ID, as specified by the server_id system ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/source-thread-states.html
This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. Master has sent all binlog to slave; waiting for more updates From MySQL 8.0.26: Source has sent all binlog to replica; ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
The way which you join upgraded members can depend on which method you are following, and other factors such as whether the group is operating in single-primary or multi-primary mode. Disable Group Replication from starting up automatically so that ... This section explains the steps required for upgrading a member of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
The lock modes reported in this section are explained in Section 17.7.1, “InnoDB Locking”. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the ...