https://dev.mysql.com/source-installation.html
Warning Building MySQL with nonstandard options may lead to reduced functionality, performance, or security. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a ...
https://dev.mysql.com/stored-programs-logging.html
Mixed format binary logging (binlog_format=MIXED) uses statement-based binary logging, except for cases where only row-based binary logging is guaranteed to lead to proper results. The binary log contains information about SQL statements that ...
https://dev.mysql.com/thread-pool-operation.html
These would lead to all resources used by only a few statements and they could prevent all others from accessing the server. The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections ...
https://dev.mysql.com/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
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. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It ...
https://dev.mysql.com/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...
https://dev.mysql.com/window-functions-usage.html
For these, the OVER clause is mandatory: CUME_DIST() DENSE_RANK() FIRST_VALUE() LAG() LAST_VALUE() LEAD() NTH_VALUE() NTILE() PERCENT_RANK() RANK() ROW_NUMBER() For details about each nonaggregate function, see Section 12.21.1, “Window Function ...
https://dev.mysql.com/windows-pluggable-authentication.html
Leading and trailing spaces not inside double quotation marks are ignored. Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an ...
