PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/gone-away.html
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. This may happen if you have been using the commands: mysql_options(..., MYSQL_OPT_READ_TIMEOUT,...) or mysql_options(..., ...You ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Statistics are also updated periodically by certain operations and under certain conditions. To improve the start up time of the mysql client and to updating statistics, you can turn off auto-rehash using the --disable-auto-rehash option. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When a floating-point or fixed-point column is assigned a value that exceeds the range ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ...(Transactions may issue many requests to InnoDB before they commit or roll back.) On modern operating systems and servers with multi-core processors, where context switching is efficient, most workloads run well without any limit on the number of concurrent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
The Group Replication communication protocol version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the group to support. Versions from MySQL 8.0.27 also allow the group communication engine to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-table.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...