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/spatial-geojson-functions.html
For more information, see Section 13.5, “The JSON Data Type”, and Section 14.17, “JSON Functions”. For example, option values of 5 and 7 mean the same (add a bounding box and a long-format CRS URN). This section describes functions for ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). Logical backup methods have these characteristics: The backup is done by ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
CHECK PARTITION to check one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of Partitions”. Column Value Table The table name Op Always check Msg_type status, error, ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
How do I tell whether a replication source server is using statement-based or row-based binary logging format? A.14.11. To ensure that catchup can occur for a replica that has been disconnected, you must not remove binary log files from the source ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
For more information, see Section 20.6.3.1, “Secure User Credentials for Distributed Recovery”. Transactions are replicated in a format that is used to apply row transformations only, without having to re-execute transactions again (row-based ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
Note When a connection attempt from an IP address is refused because the address is not in the allowlist, the refusal message always prints the IP address in IPv6 format. IPv4 addresses are preceded by ::ffff: in this format (an IPV4-mapped IPv6 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
For more information about deploying and using InnoDB Cluster, see MySQL AdminAPI. The version string displayed by the mysql client supplied with the MySQL NDB Cluster distribution uses this format: mysql-mysql_server_version-cluster ... MySQL NDB ...