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-windows-initial-start.html
Important An NDB Cluster management node caches the configuration data that it reads from config.ini; once it has created a configuration cache, it ignores the config.ini file on subsequent starts unless forced to do otherwise. Once the NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
In this scheme, each transaction in a binary log file is annotated with a sequence_number (1, 2, 3, ...), and as well as the sequence number of the most recent binary log transaction that it depends on, to which we refer as last_committed. Within a ...To use this functionality with NDB Cluster, it is necessary that the following three conditions be met: Binary log transaction dependencies are determined at the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...The elements of an instrument name ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
The relay log file name (Relay_Log_File) is set according to the relay_log_recovery setting, either a new file that was created at server start or the first relay log file present. Inconsistencies in the sequence of transactions from the relay log ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
To enable MySQL to startup and shutdown automatically, you should create a link between this file and the init script directories. The typical upgrade sequence is therefore: $> mysqladmin shutdown $> pkgrm mysql $> pkgadd -d ... You can install ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
The audit_log plugin operates in legacy mode if it is installed but the accompanying audit tables and functions are not created. It is theoretically possible for a user with sufficient permissions to mistakenly create an “abort” item in the ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
For additional information about column indexes, see Section 15.1.15, “CREATE INDEX Statement”. Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...For example, the plugin may enable restoring such dump files into an unencrypted instance or in an environment where the paths outside the data directory are not ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...