Search Results
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
-DCMAKE_BUILD_TYPE=type The type of build to produce: RelWithDebInfo: Enable optimizations and generate debugging information. Release: Enable optimizations but omit debugging information to reduce the build size. -DWITH_LTO=bool Whether to enable ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing rapidly. To the extent that the optimizer can use information about conditions on rows selected ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Optimizing InnoDB Full-Text Indexes Running OPTIMIZE TABLE on a table with a full-text index rebuilds the full-text index, removing deleted Document IDs and consolidating multiple entries for the same word, where possible. To optimize a full-text ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. When the optimizer can make use of partition pruning in performing ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-optimization-delay=milliseconds Command-Line Format --ndb-optimization-delay=# System Variable ndb_optimization_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum Value 0 Maximum Value 100000 Unit ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
If the select attempt occurs within a derived table, you can avoid this error by setting the derived_merge flag of the optimizer_switch system variable to force the subquery to be materialized into a temporary table, which effectively causes it to ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Users must have this privilege to execute OPTIMIZE LOCAL TABLE and OPTIMIZE NO_WRITE_TO_BINLOG TABLE statements. When upgrading from a previous release series, users having the SYSTEM_USER privilege are automatically granted the OPTIMIZE_LOCAL_TABLE ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/internals/en/system-variables-controlling-trace.html
A brief overview from "mysqld --verbose --help": --optimizer-trace=name Controls tracing of the Optimizer: --optimizer-trace-features=name Enables/disables tracing of selected features of the Optimizer: ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution plan. TREE provides tree-like output with more precise descriptions of query handling than the TRADITIONAL format; it is ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...