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/manual-info.html
For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). Typographical and Syntax ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or shm). All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as ...When performing a node restart or an initial node restart, all of the cluster's data nodes must be restarted in turn (also referred to as a rolling ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. LateAlloc: Allocate memory after connection to management server has been established. MaxLCPStartDelay: Time in seconds that LCP polls for checkpoint mutex (to allow other data ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
Important If you attempt to use NDB Cluster Replication with --binlog-format=STATEMENT, replication fails to work properly because the ndb_binlog_index table on the source cluster and the epoch column of the ndb_apply_status table on the replica ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication.html
Although an NDB Cluster itself depends on the NDB storage engine for clustering functionality, it is not necessary to use NDB as the storage engine for the replica's copies of the replicated tables (see Replication from NDB to other storage engines). These counters are implemented as NDB statistics _slave status variables, as seen in the output of SHOW STATUS, or in the results of queries against the SESSION_STATUS or GLOBAL_STATUS table in a mysql client session connected to a MySQL Server that is acting as a replica in NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-issues.html
Use ANALYZE TABLE tbl_name to update the key distributions for the scanned table. Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
To specify an alternative login path file name, set the MYSQL_TEST_LOGIN_FILE environment variable. Option File Processing Order Option File Syntax Option File Inclusions Option File Processing Order On Windows, MySQL programs read startup options ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/5.7/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...