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/replication-features-memory.html
Note that the replica still has outdated data in a MEMORY table during the interval between the source's restart and its first use of the table. This causes the replica to be out of synchrony with the source and may lead to other failures or cause ... When a replication source server shuts down and restarts, its MEMORY tables become ...To avoid this interval when a direct query to the replica could return stale data, you can set the init_file system variable to ...
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/mysql-cluster-programs-ndbinfo-select-all.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --loops=number, -l number Command-Line Format --loops=# Type Numeric ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
For example, to remove the limit on how many times per hour francis can connect, use this statement: mysql> ALTER USER 'francis'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 0; As mentioned previously, the simultaneous-connection limit for an account ...Only statements that modify databases or tables count against the update ... One means of restricting client use of MySQL server resources ...
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) ...