Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
Most Performance Schema tables have indexes, which gives the optimizer access to execution plans other than full table scans. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqlcheck A table-maintenance client that checks, repairs, analyzes, and optimizes tables. myisamchk A utility to describe, check, optimize, and repair MyISAM tables. Later sections provide a more detailed description of each one, with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
By default, the replication I/O (receiver) thread does not write binary log events to the relay log if they have the replica's server ID (this optimization helps save disk usage). replication_optimize_for_static_plugin_config Command-Line Format ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
It also causes OPTIMIZE TABLE to be mapped to ALTER TABLE for storage engines for which OPTIMIZE TABLE is not supported. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
An alternative to SET RESOURCE GROUP is the RESOURCE_GROUP optimizer hint, which assigns individual statements to a resource group. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
For InnoDB tables, the row count is only a rough estimate used in SQL optimization. The row count is only a rough estimate used in SQL optimization. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
This method involved opening a B-tree cursor to find the insert position and then inserting entries into a B-tree page using an optimistic insert. Sorted Index Builds and Optimizer Statistics Sorted index builds may result in optimizer statistics ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation.html
Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. We put a great deal of effort into ensuring that our binaries are built with the best possible options for optimal ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. All subquery forms and operations that the SQL standard requires are ...