PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases the usability of MySQL Server for a large segment of our user base. Today MySQL Server handles terabyte-sized databases, but the code can also be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G Empty set (0.00 sec) An empty set is returned because ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. ndbmtd is intended for use on host computers having multiple CPU cores. For ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
Thus, for any other region, this variable must be set explicitly. (It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format ...These ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
During installation, the initial database is created, and you are prompted for the MySQL root password (and confirmation). The database tables are automatically created for you, if they do not already exist. You should, however, run ... Many Linux ...Important Native packages are often several versions behind the currently available ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) and the local query handler (LQH), and written to the cluster log. Because some transactions committed in ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
BackupDiskWriteSpeedPct: Sets percentage of data node's allocated maximum write speed (MaxDiskWriteSpeed) to reserve for LCPs when starting backup. DefaultHashMapSize: Set size (in buckets) to use for table hash maps. HeartbeatOrder: Sets order in ... 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/replication-gtids-failover.html
GTIDs play a key role in applying changes to the database: the server automatically skips any transaction having an identifier which the server recognizes as one that it has processed before. See Section 16.1.3.4, “Setting Up Replication Using ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Delayed replication can be used for several purposes: To protect against user mistakes on the source. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_DELAY = N; An event received from the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
Reset the replica cluster using this statement in the mysql client: mysqlR> RESET SLAVE; You can now start the cluster restoration process on the replica using the ndb_restore command for each backup file in turn. We assume that the replication ...