PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
Like SET GLOBAL, SET PERSIST sets the global variable runtime value, but also writes the variable setting to the mysqld-auto.cnf file (replacing any existing variable setting if there is one). To persist a global system variable to the ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
MySQL also supports a native JSON data type and a set of SQL functions to enable operations on JSON values. mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. For additional information, ...This section describes how to select these protocols, and how they are similar and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog and mysql to restore the changes that occurred after the backup was made. To achieve point-in-time recovery after restoring a backup, you can ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. Setting the TIMED column affects Performance Schema table contents as described in Section 29.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion and the expulsion of the suspect member. This is also the behavior of a group ...A group member is then expelled when another member's suspicion of it (or its own suspicion of itself) times ...A suspicion is created when ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
From MySQL 8.0.24, the operation resumes if the error is resolved within the time specified by the clone_donor_timeout_after_network_failure variable defined on the donor instance. Prior to MySQL 8.0.24, donor threads use the MySQL Server ...Prior ... This section describes failure handing at different stages of a cloning ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The order in which matching occurs matters because different matching setup_objects rows can ... The setup_objects table controls whether the Performance Schema monitors particular ...