PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
MySQL recognizes the escape sequences shown in Table 14.23, “JSON_UNQUOTE() Special Character Escape Sequences”. The functions in this section modify JSON values and return the result. JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...) ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-acid.html
Details can be viewed in the INFORMATION_SCHEMA tables (see Section 17.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”) and Performance Schema data_locks and data_lock_waits tables. The ACID model is a set of database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-compared.html
While it is possible to use InnoDB tables with NDB Cluster, such tables are not clustered. Due to the differences, some usage scenarios are clearly more suitable for one engine or the other; see Section 25.2.6.2, “NDB and InnoDB Workloads”.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-computer-definition.html
The [computer] section has no real significance other than serving as a way to avoid the need of defining host names for each node in the system. Id Version (or later) NDB 8.0.13 Type or units string Default [...] Range ... Restart Type Initial ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
You should now be ready to work with databases, tables, and data in NDB Cluster. See Section 25.3.5, “NDB Cluster Example with Tables and Data”, for a brief discussion. Starting the cluster is not very difficult after it has been configured.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
The [ndb_mgmd] section is used to configure the behavior of the management server. If multiple management servers are employed, you can specify parameters common to all of them in an [ndb_mgmd default] section. [mgm] and [mgm default] are older ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-workloads.html
A number of major differences in behavior between the NDB and InnoDB storage engines with regard to some common types of database-driven application workloads are shown in the following table:: Table 25.3 Differences between InnoDB and NDB storage ... NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low ...