PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. Specifying the CHARACTER ...These might be changes to a data type, to attributes associated with a data type, or to an index ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in autocommit mode, the sequence starts over for all storage engines except InnoDB and MyISAM. In this case, reuse of values deleted from the top of the sequence ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. However, it might update zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. A ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. In the following example, the sequence of values produced by RAND(3) is the same ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
MRR iterates over a sequence of index ranges to obtain qualifying index tuples. The MRR optimization is not supported with secondary indexes created on virtual generated columns. Data rows are accessed according to the sorted index tuple sequence.
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... 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 ...