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-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/innodb-page-compression.html
row *************************** SPACE: 45 NAME: employees/employees FS_BLOCK_SIZE: 4096 FILE_SIZE: 23068672 ALLOCATED_SIZE: 19415040 Page compression metadata for the employees table shows that the apparent file size is 23068672 bytes while the ...
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/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/load-data.html
Some cases are not supported by LOAD DATA: Fixed-size rows (FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns. With IGNORE, new rows that duplicate an existing row on a unique key value are discarded. Suppose that you ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
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/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 ...