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/source-configuration-third-party.html
Third-party tools that need to determine the MySQL version from the MySQL source can read the MYSQL_VERSION file in the top-level source directory. For example, if the version is MySQL 8.0.36, the file looks like this: MYSQL_VERSION_MAJOR=8 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. For new installations, the sys schema is installed by default during data directory initialization if you use ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview-requirements.html
The MySQL software requirements are simple: all that is needed is a production release of NDB Cluster. It is not strictly necessary to compile MySQL yourself merely to be able to use NDB Cluster. We assume that you are using the binaries appropriate ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
HeartbeatIntervalDbDb: Time between data node-to-data node heartbeats; data node considered dead after 3 missed heartbeats. KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in milliseconds. LcpScanProgressTimeout: ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. This information is shown in the table's status column, which can have any one of the following values: CONNECTING, ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. | 1.5219271183014 | | 6 | When configured properly, MySQL ... The MySQL FULLTEXT ... By ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
By default, MySQL (8.0.18 and later) employs hash joins whenever possible. Note MySQL 8.0.18 supported setting a hash_join flag in optimizer_switch, as well as the optimizer hints HASH_JOIN and NO_HASH_JOIN. In MySQL 8.0.19 and later, none of these ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. This pertains to migration strategy because the way in which the source and destination keystores are managed ...A ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. There are several distinctions between the way user names and passwords are used by MySQL and your operating system: User names, as used by MySQL for authentication purposes, ...