PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Note SUBPARTITION BY HASH and SUBPARTITION BY KEY generally follow the same syntax rules as PARTITION BY HASH and PARTITION BY KEY, respectively. Subpartitioning—also known as composite partitioning—is the further division of each partition in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
Note If the performance_schema_show_processlist system variable is enabled, the processlist table also serves as the basis for an alternative implementation underlying the SHOW PROCESSLIST statement. Note A USER value of system user is distinct from ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...