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/query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
To understand the type of problem that CHECK TABLE may be encountering, refer to the InnoDB notes in Section 15.7.3.2, “CHECK TABLE Statement”. This section describes how to rebuild or repair tables or indexes, which may be necessitated by: ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
Note MySQL uses C escape syntax in strings (for example, \n to represent the newline character). This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
Column Value Table The table name Op Always repair Msg_type status, error, info, note, or warning Msg_text An informational message The REPAIR TABLE statement might produce many rows of information for each repaired table. [QUICK] [EXTENDED] ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
Note REPLACE makes sense only if a table has a PRIMARY KEY or UNIQUE index. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
Note that the defaults for these options, which were designed for a connection to a single source, make the replica retry the same connection for 60 days. To activate asynchronous connection failover for a replication channel set ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Note If you use LOAD DATA when binlog_format=STATEMENT is set, which is not recommended as the statement is considered unsafe for statement-based replication, a temporary file containing the data is created on the replica where the changes are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
If you back up encrypted binary log files using mysqlbinlog, note that the copies of the files that are generated using mysqlbinlog are stored in an unencrypted format. From MySQL 8.0.14, binary log files and relay log files can be encrypted, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
Note Each channel on a multi-source replica must replicate from a different source. In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. The replication channels represent the path of ...