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/windows-upgrading.html
Deselect all but the MySQL server product, unless you intend to upgrade other products at this time, and click Next. Prior to MySQL 8.0.16, run mysql_upgrade as Administrator to check your tables, attempt to repair them if necessary, and update your ...Significant development changes take place in non-GA releases and you may encounter compatibility issues or problems starting the ... There are two approaches for upgrading MySQL on Windows: Using ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
When a given index value yields a large number of rows, the index is less useful and MySQL is less likely to use it. The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
When you use a randomly generated value as a primary key in an InnoDB table, prefix it with an ascending value such as the current date and time if possible. For character and string columns, follow these guidelines: Use binary collation order for ...You can use the BINARY operator to use binary collation within a particular ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...Fortunately, this is the default behavior for a new MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and --verbose options may be used to affect row event output. # at 302 #080828 15:03:08 server id 1 ... The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...The following figure presents a block diagram depicting the overall architecture of MySQL Group ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). Functions in this section detect arguments in either Cartesian or geographic spatial ...For ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
If a timeout is specified, and timeout seconds elapse before all of the transactions in the GTID set have been applied, the function stops waiting. timeout is optional, and the default timeout is 0 seconds, in which case the function always waits ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-secretsfile-reader.html
Usage ndb_secretsfile_reader options file The options must include one of --filesystem-password or --filesystem-password-from-stdin, and the encryption password must be supplied, as shown here: > ndb_secretsfile_reader --filesystem-password=54kl14 ... ndb_secretsfile_reader gets the encryption key from an NDB encryption secrets file, given the ...