Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table 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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Writes to the tablespace that occur after setting the new compression algorithm use the new setting, but to apply the new compression algorithm to existing pages, you must rebuild the table using OPTIMIZE TABLE. ALTER TABLE t1 COMPRESSION="zlib"; ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
The following problems are known: Subquery optimization for IN is not as effective as for =. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having different ranks, hence getting a different number in ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to look up rows. This is optimized by a preprocessor that checks whether you are using WHERE key_part_N = constant on all key parts that occur ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before the inner tables. The optimizer choices are limited because only such plans ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
INSERT is also required for the ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE table-maintenance statements. OPTIMIZE_LOCAL_TABLE Enables use of OPTIMIZE LOCAL TABLE and OPTIMIZE NO_WRITE_TO_BINLOG TABLE statements. A user with this privilege can ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
This read method is mainly used to optimize ORDER BY ... Last_query_cost The total cost of the last compiled query as computed by the query optimizer. Last_query_partial_plans The number of iterations the query optimizer made in execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
(See Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”.) Example: UPDATE t ... In general, you may be able to influence the optimizer to materialize a derived table by ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Under those conditions, the comparison in the WHERE clause occurs in different ways for ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Common Table Expressions Recursive Common Table Expressions Limiting Common Table Expression Recursion Recursive Common Table Expression Examples Common Table Expressions Compared to Similar Constructs For information about CTE optimization, see ...