PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
Each cluster node process must be started separately, and on the host where it resides. Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html
The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
An ER_GIS_INVALID_DATA error occurs for the additional condition that any coordinate value of the two points is infinite or NaN. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. For functions ... The functions in this section provide convenience operations on geometry ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
PARTITION BY statement must follow the same rules as one created using CREATE TABLE ... Any data that was stored in the dropped partitions named in the partition_names list is discarded. TABLESPACE options extend the Transportable Tablespace feature ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ... Partitioning-related clauses for ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
This statement works for InnoDB tables as well, but there is no such concept because there is no separate data file. If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
This includes variables set within files specified using the init_file system variable. EXPLICIT The variable was set from an option file named with the --defaults-file option. EXTRA The variable was set from an option file named with the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
(In NDB 7.6 and earlier, this was 48.) A data node must have a node ID in the range of 1 to 144, inclusive. Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. See ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
This column is reserved for future use, in case new error conditions must be reported, and if preserving the backward compatibility and structure of the host_cache table is required. While HOST_VALIDATED is NO, DNS resolution is attempted for each ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Operations performed by a restricted client result in an error until the user establishes a new account password: mysql> SELECT 1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. If ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). The disadvantage of this is that you must ensure that your statements always refer to your database and ... In MySQL, databases correspond to directories within the data ...One notable exception is macOS, which is Unix-based ...