Search Results
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
Condition filtering enables the optimizer to use other relevant conditions in the WHERE clause not taken into account by the access method, and thus improve its prefix row count estimates. It was not already taken into account by the access method.
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
Check that OpenSSL was correctly integrated into the Path variable by opening a new command console (Start>Run>cmd.exe) and verifying that OpenSSL is available: Microsoft Windows [Version ...] Copyright (c) 2006 Microsoft Corporation. This section ...
https://dev.mysql.com/doc/refman/8.4/en/displaying-traces.html
INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines. As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON.
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). External off-page storage for variable-length columns differs by row format: COMPACT and REDUNDANT Row ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
This functionality is intended for loading data into a new MySQL instance. Warning This feature is intended only for loading data into a new MySQL instance. The following procedure demonstrates how to disable redo logging when loading data into a ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. Configure the Distribution Change location into the top-level directory of the unpacked distribution: $> cd ... To ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. The scope of a local variable is the BEGIN ... The variable can be referred to in ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. --join=big_tbl_name, -j big_tbl_name Command-Line Format --join=big_tbl_name Type String Join all tables named on the command line into a single ...This results in much better performance when accessing individual rows, because you only have to uncompress exactly one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...An ...