PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
Example data lock wait information: mysql> SELECT * FROM performance_schema.data_lock_waits\G *************************** 1. Use the data_lock_waits table to help diagnose performance problems that occur during times of heavy concurrent load. Note ... The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
UNREACHABLE: The failure detection process suspects that this member cannot be contacted, because the group messages have timed out. MEMBER_COMMUNICATION_STACK The communication stack used for the group, either the XCOM communication stack or the ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...If you are using replication, you should specify an expiration period that is no lower than the maximum amount of time your replicas might lag behind the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for transmission, and should therefore be protected in transit by the use of connection encryption (see Section 8.3, “Using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. The validate_password plugin is deprecated; expect it to be removed in a future version of MySQL. MySQL installations that currently use the ...In ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. Consider increasing the value if you experience slower response times due to long-running ...
https://dev.mysql.com/doc/refman/8.0/en/activestate-perl.html
On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install it. For example, you might try a setting like this: C:\> set ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
The number member of the MY_CHARSET_INFO data structure returned by the mysql_get_character_set_info() C API function. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html
Note If you are looking for information about the authentication_oci plugin, it is MySQL HeatWave Service only. The following sections describe pluggable authentication methods available in MySQL and the plugins that implement these methods. For ...