PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-ssl-rsa-setup.html
Note mysql_ssl_rsa_setup uses the openssl command, so its use is contingent on having OpenSSL installed on your machine. Instead, consider using MySQL server to generate missing SSL and RSA files automatically at startup (see Automatic SSL and RSA ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
Note If the OpenSSL FIPS Object Module is not available, the only permitted value for --ssl-fips-mode is OFF. The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Note If the --auto-generate-sql option is also given, mysqlslap drops the schema at the end of the test run. Note If the OpenSSL FIPS Object Module is not available, the only permitted value for --ssl-fips-mode is OFF. mysqlslap is a diagnostic ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
Note A known limitation is that, within MySQL, host name resolution does not work for names specified in network namespace-specific host files. A network namespace is a logical copy of the network stack from the host system. Network namespaces are ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Column Value Table The table name Op Always optimize Msg_type status, error, info, note, or warning Msg_text An informational message OPTIMIZE TABLE table catches and throws any errors that occur while copying table statistics from the old file to ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Note The block-nested loop optimization is removed in MySQL 8.0.20 and later releases, but BNL and NO_BNL continue to be supported for enabling and disabling hash joins. Note To use a block nested loop or batched key access hint to enable join ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
Note Although this option was introduced in MySQL 8.0.20, its behavior was 120 in MySQL 5.7. Note Because the doublewrite buffer setting is global, the doublewrite buffer is also disabled for data files that do not reside on Fusion-io hardware. If ...
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note For brevity, CREATE USER statements shown here do not include passwords. Prior to MySQL 8.0.16, it is not possible to ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...