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/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...Two functions providing basic XPath 1.0 (XML Path Language, version 1.0) capabilities are ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
For queries that use the SQL_SMALL_RESULT modifier, MySQL uses an in-memory temporary table, unless the query also contains elements (described later) that require on-disk storage. SELECT statements that select from and insert into the same table, ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
The execution times reported for these statements in the mysql client correlate roughly with these figures. mysqld exposes these counters as system status variables; their values can be read in the output of SHOW STATUS, or by querying the ... A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
To assure continuity of NDB replication, it is necessary to upgrade the cluster's SQL nodes in such a way that at least one mysqld is acting as the replication source at any given point in time during the upgrade. As when upgrading, it is necessary ...In-place upgrades of the included MySQL Server (SQL node mysqld) are also supported; with multiple SQL nodes, it is possible to keep an SQL application online while individual mysqld processes are ... Versions Supported for Upgrade to NDB 8.0 Reverting an NDB Cluster 8.0 Upgrade Known Issues When ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
If a connector links to libmysqlclient dynamically, it must be ensured that the newer version of libmysqlclient is installed on the client host and that the connector loads it at runtime. When a client connects to the MySQL server, the server uses ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. For additional information and ...These options can be given on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. MySQL distributions include several plugins that implement server ...The ...
https://dev.mysql.com/doc/refman/8.0/en/uln-installation.html
Linux supports a number of different solutions for installing MySQL, covered in Section 2.5, “Installing MySQL on Linux”. Both Community and Commercial packages are supported, and each offers three MySQL channels: Server: MySQL Server ...One of ...