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-reference-systems.html
The SRS denoted in MySQL by SRID 0 represents an infinite flat Cartesian plane with no units assigned to its axes. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for ... A ...
https://dev.mysql.com/doc/refman/8.0/en/union.html
Compared to MySQL 5.7, several user-visible effects resulted from this work, which may require rewriting of certain statements: NATURAL JOIN permits an optional INNER keyword (NATURAL INNER JOIN), in compliance with standard SQL.
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...A dump file can be used in several ways: As a backup to enable data recovery in case of data ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-md5-checksum.html
After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. The correct MD5 checksum is listed on the downloads page for each MySQL product; you should compare it ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table ...For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
If an upgraded replication source server still has old replicas using MySQL versions that do not support multiple triggers, an error occurs on those replicas if a trigger is created on the source for a table that already has a trigger with the same ...It is sufficient to switch to statement-based replication only for those statements where you want this effect, and to use row-based replication the rest of the ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
As of MySQL 8.0.14, the timestamp indicates when the slow statement began executing. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...By ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
The flag is checked in each major loop in MySQL, but in some cases it might still take a short time for the thread to die. The temporary result set has become too large (see Section 10.4.4, “Internal Temporary Table Use in MySQL”). Killed ...