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/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts. The innodb_redo_log_capacity variable supersedes the innodb_log_file_size and innodb_log_files_in_group variables, which are deprecated.
https://dev.mysql.com/doc/refman/8.0/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
In some cases, a GROUP BY can be resolved by reading the index in order (or doing a sort on the index), then calculating summaries until the index value changes. In this case, LIMIT row_count does not calculate any unnecessary GROUP BY values. If ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-services.html
In this case, you can use the [mysqld1] group for 5.7.9 and the [mysqld2] group for 8.0.44. In this case, each file should list options using a [mysqld] group. On Windows, a MySQL server can run as a Windows service. The procedures for installing, ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
myisamchk supports the following options, which can be specified on the command line or in the [myisamchk] group of an option file. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-basics.html
There are as many data nodes as there are fragment replicas, times the number of fragments (see Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”). For a brief introduction to the relationships between nodes, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-exclusive-to-cluster.html
The following are limitations specific to the NDB storage engine: Machine architecture. All machines used in the cluster must have the same architecture. That is, all machines hosting nodes must be either big-endian or little-endian, and you cannot ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
The maximum number of partitions that can defined for a NDBCLUSTER table when employing user-defined partitioning is 8 per node group. (See Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”, for more information ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...