PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html
The server SSL options that are applied to Group Replication's group communication connections are as follows: Table 20.2 SSL Options Server Configuration Description ssl_key The path name of the SSL private key file in PEM format. ssl_cert The path ...The Group Replication system variable group_replication_ssl_mode is used to activate the use of SSL for group communication connections and specify the security mode for the ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must ...If you use myisamchk for write operations such as repairing or optimizing tables, or if you use myisampack to pack tables, you must always ensure that the mysqld server is not using the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
SOURCE The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs. For example, it can be used with GROUP BY OBJECT_INSTANCE_BEGIN to see whether the load ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. The FEDERATED storage ...To include the FEDERATED storage engine if you build MySQL from source, invoke CMake with the -DWITH_FEDERATED_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
A “record” in the keystore consists of data (the key itself) and a unique identifier through which the key is accessed. The function stores into it a pointer to the buffer containing the fetched key data. The type and length values must be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-gr-memory-monitoring-ps-instruments.html
Gcs_message_data::m_buffer: Memory allocated for the transaction data payload sent to the network. certification_data_gc: Memory allocated for the GTID_EXECUTED sent by each member for garbage collection. transaction_data: Memory allocated for ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log plugin must be enabled or an error occurs. In addition, the audit tables must exist or an error ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...If the plugin is installed without the accompanying audit tables and functions needed ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
Disabling ONLY_FULL_GROUP_BY is useful primarily when you know that, due to some property of the data, all values in each nonaggregated column not named in the GROUP BY are the same for each group. The following discussion demonstrates functional ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. You can use mysqlbinlog to ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...