PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. This is analogous to the way that MySQL interprets TIME values as representing elapsed time ... This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. The innodb_ft_num_word_optimize option defines the number of words that are optimized each time OPTIMIZE TABLE is run. The default setting is 2000, which means ...
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. You can change the time limit by setting the wait_timeout variable when you start mysqld. You got a timeout from the TCP/IP ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
To avoid this situation, ensure that you set the threshold to a number higher than the number of transactions that you would expect to occur in the group during the time taken for the remote cloning operation. A remote cloning operation might take ...If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
When a suspicion times out, the suspected member is assumed to have failed, and is expelled from the group. By default, the following behaviors happen if a member is suspected of having failed: Up to MySQL 8.0.20, when a suspicion is created, it ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_WAIT_STARTED The time when the transaction started waiting on the lock, if TRX_STATE is LOCK WAIT; otherwise NULL. During times of contention, it counts down to zero, and statements release the latch immediately after each row lookup. The ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/innodb-fulltext-index.html
The caching and batch flushing behavior avoids frequent updates to auxiliary index tables, which could result in concurrent access issues during busy insert and update times. If you create a full-text index at CREATE TABLE time and do not specify an ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...