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/optimizer-issues.html
In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make “educated” guesses about the data. MySQL uses a cost-based optimizer to determine the ...Use ANALYZE TABLE tbl_name to update the key distributions for the scanned ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. Required table repairs or upgrades reported by CHECK TABLE, mysqlcheck, or mysql_upgrade.
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
This is called statement-based replication (which can be abbreviated as SBR), which corresponds to the MySQL statement-based binary logging format. You can also configure MySQL to use a mix of both statement-based and row-based logging, depending on ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
The following functions, which are available from MySQL 8.0.22 for standard source to replica replication and from MySQL 8.0.23 for Group Replication, enable you to add and remove replication source servers from the source list for a replication ...
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/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 ...