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-asynchronous-connection-failover-replica.html
In MySQL 8.0.27 and later, asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
Replication works because events written to the binary log are read from the source and then processed on the replica. The correlation between binary logging formats and the terms used during replication are: When using statement-based binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
This feature enables replication from a source server that does not have GTIDs enabled and does not use GTID-based replication, to a replica that has GTIDs enabled. Note that as is standard for MySQL replication, this feature does not support ...
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
Note This statement is replaced in later versions of MySQL by RESET BINARY LOGS AND GTIDS, and should be considered deprecated. See RESET BINARY LOGS AND GTIDS Statement, in the MySQL 8.4 Manual, for more information. RESET MASTER [TO ...A new ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...ST_AsGeoJSON(g [, max_dec_digits [, options]]) Generates a GeoJSON object from the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
MySQL Installer downloads and applies updates to itself, and to each of the installed products. MySQL Installer This package has a file name similar to mysql-installer-community-8.0.44.0.msi or mysql-installer-commercial-8.0.44.0.msi, and utilizes ... For MySQL 8.0, there are multiple installation package formats to choose from when installing MySQL on ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
If the operation does not resume within the allotted time, it aborts and returns an error, and the donor drops the snapshot. Prior to MySQL 8.0.24, donor threads use the MySQL Server wait_timeout setting when listening for Clone protocol commands.
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This time we have a column with a latin1 character set and a default collation. The following ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
There are additional write costs to consider when using a secondary index on a virtual column due to computation performed when materializing virtual column values in secondary index records during INSERT and UPDATE operations. A secondary index ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...