PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision values and eight bytes for double-precision values. For FLOAT, the SQL standard permits an optional specification of the precision (but ...MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. Also, functions such as ST_GeomFromText() that accept WKT geometry collection arguments understand both OpenGIS 'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL ...The functions described in this section are MySQL extensions to the OpenGIS ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. For Point objects that have a geographic spatial reference system (SRS), the longitude and latitude may be obtained using the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-securing.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...For a full description of distributed recovery, see Section 20.5.4, “Distributed ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fine-tuning-the-group-communication-thread.html
The GCT receives messages from the group and from the plugin, handles quorum and failure detection related tasks, sends out some keep alive messages and also handles the incoming and outgoing transactions from/to the server/group. This is because ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
Operating with a single consensus leader improves performance and resilience in single-primary mode, particularly when some of the group’s secondary members are currently unreachable. The Performance Schema table ... By default, the group ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X. Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. row *************************** SPACE_ID: 4294967294 INDEX_ID: 65 N_CACHED_PAGES: 45 This query returns the number of index pages ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ...The INNODB_INDEXES table has these columns: INDEX_ID An identifier for the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-plugins-table.html
The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL ...