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-compatibility.html
This is due to a number of factors: Binary log format changes. This also has significant implications for upgrading replication servers; see Section 19.5.3, “Upgrading a Replication Topology”, for more information. For more information about ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. This causes the replica to be out of synchrony with the source and ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
This section provides information about restrictions on and limitations of replication with GTIDs. SELECT statement is recorded in the binary log as one transaction with one GTID, but if ROW format is used, the statement is recorded as two ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids.html
You can use either statement-based or row-based replication with GTIDs (see Section 19.2.1, “Replication Formats”); however, for best results, we recommend that you use the row-based format. This section discusses the following topics: How GTIDs ... This section explains transaction-based replication using global transaction identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Analytics - live data can be created on the source, while the analysis of the information can take place on the replica without affecting the performance of the source. For information on how to use replication in such scenarios, see Section 19.4, ... Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
For information on troubleshooting ALTER TABLE, see Section B.3.6.1, “Problems with ALTER TABLE”. For information about generated columns, see Section 15.1.9.2, “ALTER TABLE and Generated Columns”. See Multi-Valued Indexes, for detailed ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.