PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
Once the connection retry limit is reached the recovery procedure terminates with an error. In earlier versions of Group Replication, when reaching out to a donor, recovery could only detect connection errors due to authentication issues or some ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
This capability has the following limitations: The size of the insert cannot exceed the maximum packet size between servers. ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. Also, if the ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. Use cases for this plugin ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
For example, if you attempt a second ALTER TABLE operation, the result may be an error Table 'tbl_name' was not locked with LOCK TABLES. (This is a very convenient way to get backups if you have a file system such as Veritas that can take snapshots ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the host. These views summarize informaion about statements executed, grouped by host and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the user. These views summarize informaion about statements executed, grouped by user and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
max_latency The maximum single wait time of timed I/O events for the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread. total_latency The total wait time of timed I/O events for the thread. min_latency ...The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
In this case, the server does not acquire the query cache mutex at all, which means that the query cache cannot be enabled at runtime and there is reduced overhead in query execution. Note You can set the maximum size that can be specified for the ...For example, a client can disable use of the query cache for its own queries like this: mysql> SET SESSION query_cache_type = OFF; If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values are ...