Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
This is similar to --base64-output=NEVER but does not exit with an error if a row event is found. The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. The following discussion covers these MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. This section describes how to use mysqldump to create delimited-text dump files. For ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Look for warnings or errors while the dump file is being processed. When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production version. Then you can dump the database and database object ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-memory-management.html
Defining an appropriate buffer size limit avoids potential out of memory errors for online DDL operations that create or rebuild secondary indexes. Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
Programs that do not understand the option quit after displaying an error message if you try to run them. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1 type: range possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: NULL rows: 7 Extra: Using where If EXPLAIN is used to examine a query against a nonpartitioned ...