Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
For INFORMATION_SCHEMA tables implemented as views on data dictionary tables, indexes on the underlying data dictionary tables permit the optimizer to construct efficient query execution plans. Applications that monitor databases may make frequent ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
MySQL uses a cost-based optimizer to determine the best way to resolve a query. For example, start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than ...In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make “educated” guesses about the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Consider the following guidelines for optimizing redo logging: Increase the size of your redo log files. Optimize the use of spin delay by user threads waiting for flushed redo. When InnoDB has written redo log files full, it must write the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-subqueries.html
Development is ongoing, so no optimization tip is reliable for the long term. See also Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. The following list provides some interesting tricks ...
https://dev.mysql.com/doc/refman/8.4/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/internals/en/optimizer-joins.html
This section discusses the various methods used to optimize joins.
https://dev.mysql.com/doc/internals/en/optimizer-partitioning-related.html
See Partitioning for general information about the partitioning implementation in MySQL 5.1 and later.
https://dev.mysql.com/doc/internals/en/optimizer-tracing.html
In MySQL 5.6, a new tracing capability was added to the MySQL optimizer. The interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table, but is subject to change.
https://dev.mysql.com/doc/internals/en/optimizer.html
This chapter describes the operation of the MySQL Query optimizer, which is used to determine the most efficient means for executing queries.