PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-basics.html
Generally speaking, when data is saved to disk, it is said that a checkpoint has been reached. NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data-persistence features. The NDBCLUSTER storage engine can ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-event-reports.html
By default, the cluster log is saved to a file named ndb_node_id_cluster.log, (where node_id is the node ID of the management server) in the management server's DataDir. Cluster logging information can also be sent to stdout or a syslog facility in ... In this section, we discuss the types of event logs provided by NDB Cluster, and the types of events that are ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-configuration.html
The management node needs a config.ini file telling it how many fragment replicas to maintain, how much memory to allocate for data and indexes on each data node, where to find the data nodes, where to save data to disk on each data node, and where ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
--stats Command-Line Format --stats Introduced 5.7.20-ndb-7.6.4 Save information about options related to performance and other internal statistics in files named *.sto and *.stt. ndb_import imports CSV-formatted data, such as that produced by ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
SET unique_checks=1; For big tables, this saves a lot of disk I/O because InnoDB can use its change buffer to write secondary index records in a batch. SET foreign_key_checks=1; For big tables, this can save a lot of disk I/O. These performance ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
This means the replica's record of the current position read from the source's binary log (in the source metadata repository) is never ahead of the record of transactions saved in the relay log. This setting, which is the default, ensures that ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
A client user who can connect to the server some other way can use a SHOW STATUS LIKE 'Rsa_public_key' statement and save the returned key value in a file. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
If you use statement-based or mixed binary logging format, do not use cross-database queries, and do not specify database names in queries. For both DDL and DML statements, rely on the USE statement to specify the current database, and use only the ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
In such cases, all index-using queries of the form shown match at most one index entry. It remains true that index-using queries match the converted search value to a single value in the UTC index entries, rather than matching multiple UTC values ...