PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-shutdown-restart.html
To shut down the cluster, enter the following command in a shell on the machine hosting the management node: $> ndb_mgm -e shutdown The -e option here is used to pass a command to the ndb_mgm client from the shell. The command causes the ndb_mgm, ...On Windows platforms, assuming that you have installed the SQL node as a Windows service, you can use SC STOP service_name or NET STOP ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
Assume that you are running MySQL on a computer whose host name is “tonfisk”, and consider the following invocation of mysqld_safe: $> mysqld_safe & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to '/usr/local/mysql/var/tonfisk.err'. 080112 ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...Replication between tables that have different partitioning is generally not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. TRUNCATE TABLE is treated for purposes of logging and replication as ...However this caused issues when logging or replicating, in STATEMENT or MIXED mode, tables that used transactional storage engines such as InnoDB when the transaction isolation level was READ COMMITTED or READ UNCOMMITTED, which precludes statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...As such, the implementation of SHOW PROCESSLIST which uses this table is also ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
Note When adding FTS_DOC_ID column at table creation time, ensure that the FTS_DOC_ID column is updated when the FULLTEXT indexed column is updated, as the FTS_DOC_ID must increase monotonically with each INSERT or UPDATE. If you choose not to add ...To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET autocommit=0; ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. SSL certificate and key ...