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/x-plugin-encrypted-connections.html
For example, X Plugin can have SSL key, certificate, and certificate authority files that differ from those used for MySQL Server. These variables are described at Section 22.5.6.2, “X Plugin Options and System Variables”. Encryption per ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...For ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...MySQL offers a variety of backup strategies from which you can choose the methods that best suit the requirements for your ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.21.3, “The host_cache Table”. It takes more than connect_timeout seconds to obtain a connect packet. If a client successfully connects but later disconnects improperly ... If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range queries. Multiple get Operations The ability to fetch multiple key-value pairs in a single memcached query ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the ...(Bug #45677) An INSERT into a table that has a composite primary key that ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. Time zone The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. row ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ...See Section 26.6.1, “Partitioning Keys, Primary Keys, and Unique Keys”, for more ... Partitioning by HASH is used ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. For storage engines that use only ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, SUBPARTITION_METHOD, PARTITION_EXPRESSION, SUBPARTITION_EXPRESSION, CREATE_TIME, UPDATE_TIME, CHECK_TIME, CHECKSUM, and TABLESPACE_NAME columns are all NULL. UPDATE_TIME The ...