https://dev.mysql.com/bit-functions.html
(The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.) Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned ...
https://dev.mysql.com/delete.html
DELETE QUICK is not useful when deleted values lead to underfilled index blocks spanning a range of index values for which new inserts occur again. In this case, use of QUICK can lead to wasted space in the index that remains unreclaimed. DELETE is ...
https://dev.mysql.com/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Under those conditions, the comparison in the WHERE clause occurs in different ways for ...
https://dev.mysql.com/group-replication-options.html
Warning Use caution when enabling this option as incorrect usage can lead to conflicts in the group and rollback of transactions. Starting two servers or restarting one server with this option set while the group is running may lead to an artificial ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/innodb-compression-internals.html
Files are typically divided into fixed-size blocks that are compressed into variable-size blocks, which easily leads into fragmentation. Depending on the workload, this smaller database can in turn lead to a reduction in I/O, and an increase in ...
https://dev.mysql.com/innodb-compression-tuning.html
If the system performs DML operations on compressed tables, and the way the data is distributed leads to expensive compression failures at runtime, you might adjust additional advanced configuration options. If the compressed page size is set too ...
https://dev.mysql.com/bit-value-literals.html
A leading 0b is case sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. When replicating partitioned tables, differing SQL modes on ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/innodb-index-types.html
Accessing a row through the clustered index is fast because the index search leads directly to the page with all the row data. Every InnoDB table has a special index called the clustered index where the data for the rows is stored. To get the best ...
https://dev.mysql.com/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed ...
