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/replication-options-binary-log.html
Where possible, rows stored in the binary log are grouped into events with a size not exceeding the value of this setting. If you often use large transactions, you can increase this cache size to get better performance by reducing or eliminating the ...If an event cannot be split, the maximum size can be ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-reduce.html
The minimum setting for the XCom message cache size is 1 GB up to MySQL 8.0.20. Having a very low group_replication_message_cache_size setting is not recommended if the host is on an unstable network, because a smaller message cache makes it harder ...From MySQL 8.0.21, the minimum setting is 134217728 bytes (128 MB), which enables deployment on a host that has a restricted amount of available ...
https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html
But typically you don't want to see the entire table, particularly when it becomes large. As shown in the preceding section, it is easy to retrieve an entire table. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ...Increasing innodb_stats_persistent_sample_pages too much, however, could cause ANALYZE TABLE to run ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
However, the row constructor itself does not cover an index prefix, with the result that the optimizer uses only c1 (key_len=4, the size of c1): mysql> EXPLAIN SELECT * FROM t1 WHERE c1=1 AND (c2,c3) > (1,1)\G *************************** 1. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. Any index where the before-image of the row event does not contain all the columns of the index. If ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-increase.html
However, if the transactions that happened during the member's absence have been deleted from the other members' XCom message caches because their maximum size limit was reached, the member cannot reconnect in this way. Although the group members ...