PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Once the donor is selected, the server joining the group establishes an asynchronous replication connection. new_member> CHANGE MASTER TO MASTER_USER="rec_ssl_user" FOR CHANNEL "group_replication_recovery"; new_member> START GROUP_REPLICATION; ...
https://dev.mysql.com/doc/refman/5.7/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. You can also access the same InnoDB ...Instead of formulating queries in SQL, you can use simple get, set, and incr operations that avoid the performance overhead associated with SQL parsing and constructing a query optimization ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/5.7/en/installation-layouts.html
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows” Section 2.8.3, “MySQL Layout for Source Installation” Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package” Table 2.12, “MySQL Installation Layout ... The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() shows the amount of storage space used by a ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so the keyring plugin must be loaded and available prior to InnoDB initialization. InnoDB tablespace encryption requires that the keyring plugin to be used be loaded ... Keyring service consumers require that a keyring plugin be ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
As a result of the MDL reimplementation, uniquely named locks acquired with GET_LOCK() appear in the Performance Schema metadata_locks table. In the case that multiple locks are acquired for the same name, only the first lock for the name registers ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you monitor locking service locks acquired or waited for by examining the Performance Schema metadata_locks table. MySQL distributions ...