MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 151 to 160 of 163 total results

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html

A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...

19.1.4.4 Verifying Replication of Anonymous Transactions

https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html

There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...

19.1.6.5 Global Transaction ID System Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html

Important The maximum number of GTIDs available on a given server instance is equal to the number of non-negative values for a signed 64-bit integer (263 - 1). The MySQL Server system variables described in this section are used to monitor and ...

8.1.3 Making MySQL Secure Against Attackers

https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html

To make FILE-privilege operations a bit safer, files generated with SELECT ... When you connect to a MySQL server, you should use a password. All other information is transferred as text, and can be read by anyone who is able to watch the ...

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

The value is a bitmask; bits are defined in the openssl/ssl.h header file: # define SSL_VERIFY_NONE 0x00 # define SSL_VERIFY_PEER 0x01 # define SSL_VERIFY_FAIL_IF_NO_PEER_CERT 0x02 # define SSL_VERIFY_CLIENT_ONCE 0x04 SSL_VERIFY_PEER indicates that ... The MySQL server maintains many status variables that provide information about its ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html

If a larger value is given, only the lower 32 bits are used. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different ...

14.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html

The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...

13.4.5 Spatial Reference System Support

https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html

Earth is a bit shorter in its North-South axis than its East-West axis, so a slightly flattened sphere is more correct, but perfect spheres permit faster calculations. A spatial reference system (SRS) for spatial data is a coordinate-based system ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html

CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). The string data types are CHAR, VARCHAR, ...

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html

Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point before comparison, which is not capable of representing all 64-bit integers exactly. When an ...

Displaying 151 to 160 of 163 total results