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/innodb-performance-spin_lock_polling.html
If the mutex or rw-lock becomes available during this period, the thread can continue immediately, in the same time slice. InnoDB minimizes this issue by forcing a random delay between polls to desychronize polling activity. In this way, the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
This type of undo log benefits performance by avoiding redo logging I/O. This leaves 96 rollback segments that can be assigned to transactions that modify data in regular tables. This occurs when the rollback segment assigned to a transaction runs ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespaces.html
This option can only be configured when initializing the MySQL instance. Configuring Undo Tablespaces This procedure describes how to configure undo tablespaces. Use this statement to check the value of innodb_undo_tablespaces: mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”.
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
You cannot set this up as a source or a replica (no replication). As of MySQL 5.7.8, the default value for this directory can be set at build time with the INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR CMake option. The embedded server has the following ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
This time is determined by the value of the key_cache_age_threshold component of the key cache. To avoid this, you must use a midpoint insertion strategy with the key_cache_division_limit set to much less than 100. By default, the key cache ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. For this you can insert statements like this: SELECT ...To do so, create a text file text_file that contains the statements you wish to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-configuration.html
This should be the sum of the memory allocated for the backup data buffer and the backup log buffer. This applies for both the backup data buffer and the backup log buffer. This applies for both the backup data buffer and the backup log buffer.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
In this section, we discuss and compare some characteristics of the NDB storage engine used by NDB 7.5 with InnoDB used in MySQL 5.7. While it is beyond the scope of this documentation to provide specifics for every conceivable usage scenario, we ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration.html
This engine is also referred to sometimes as NDBCLUSTER, although NDB is preferred. This MySQL server is a part of the cluster, so it also must know how to access a management node to obtain the cluster configuration data. However, should you need ... A MySQL server that is part of an NDB Cluster differs in one chief respect from a normal (nonclustered) MySQL server, in that it employs the NDB storage ...