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/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from a bugfix series like MySQL 8.4, or use an innovation release like MySQL 9.6. The naming scheme in MySQL ...Both tracks include bug fixes while an innovation release includes the newest ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...The MeCab full-text parser plugin is supported for use with InnoDB and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
mysql> SET @ls = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))); +----------------------------------------------+ | ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) | ...You can extract particular points of a ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). Decide on Upgrade Type There are three main ways to upgrade MySQL, read the associated documentation to determine which ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
As of MySQL 8.0.14, additional undo tablespaces can be created at runtime using SQL. Prior to MySQL 8.0.23, an undo tablespace is extended four extents at a time. As of MySQL 8.0.14, additional undo tablespaces can be created at runtime using CREATE ...Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be ... Undo tablespaces ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-api-definition.html
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. Note For a discussion of MySQL server options for NDB Cluster, see Section ...If no computer or host name is provided, any host can use this SQL or API ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The plugin works with these KMIP-compatible products: Oracle Key Vault Gemalto SafeNet KeySecure Appliance Townsend Alliance Key Manager Entrust ...The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high availability. The following sections show how to use the ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Other language interfaces can provide support for prepared statements that use the binary ...Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ...