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/xa.html
For example, when a Transaction Manager finds that a global transaction consists of only one transactional resource (that is, a single branch), that resource can be told to prepare and commit at the same time. This document is published by The Open ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
row *************************** ID: 5 USER: event_scheduler HOST: localhost DB: NULL COMMAND: Daemon TIME: 137 STATE: Waiting on empty queue INFO: NULL *************************** 2. row *************************** ID: 9 USER: me HOST: ...Otherwise ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). See Section 14.7, “Date and Time Functions”, for more information about such functions. However, it is not difficult ...This type of partitioning is similar to partitioning by HASH, except that only one or more columns to be evaluated are supplied, and the MySQL server provides its own hashing ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
The default is OFF; that is, the manager thread for ordinary connections on the main interface also handles connections for the administrative interface. These lines in the server my.cnf file enable the administrative interface on the loopback ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. Otherwise, see http://www.gnupg.org/ for more information about GnuPG and how to obtain and install it. The keyID for MySQL 8.0.44 packages ...This is more reliable than using MD5 checksums, but requires more ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
Consider the following query: SELECT * FROM employee JOIN department ON employee.dept_no = department.dept_no WHERE employee.first_name = 'John' AND employee.hire_date BETWEEN '2018-01-01' AND '2018-06-01'; Suppose that the data set has these ...To ... In join processing, prefix rows are those rows passed from one table in a join to the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-syslog.html
It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). This section describes how to configure error logging using the built-in filter, log_filter_internal, and the ...For general information about configuring error logging, see Section 7.4.2.1, “Error Log ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), ...For a description of WKT format, see Well-Known Text (WKT) ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
The qualifier character is a separate token and need not be contiguous with the associated identifiers. The permitted qualifiers for object names depend on the object type: A database name is fully qualified and takes no qualifier: CREATE DATABASE ...An unqualified name is permitted in contexts where interpretation of the name is ...