Search Results
https://dev.mysql.com/doc/refman/8.4/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
Furthermore, given that changes are propagated and applied in row-based format, this means that they are received in an optimized and compact format, and likely reducing the number of IO operations required when compared to the originating member.
https://dev.mysql.com/doc/refman/8.4/en/handler.html
The handler interface does not have to provide a consistent look of the data (for example, dirty reads are permitted), so the storage engine can use optimizations that SELECT does not normally permit. HANDLER tbl_name OPEN [ [AS] alias] HANDLER ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
INTRINSIC indicates that the tablespace is used for optimized internal temporary tables use by the optimizer. The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
When this column and TRX_IS_READ_ONLY are both 1, InnoDB optimizes the transaction to reduce the overhead associated with transactions that change table data. The INNODB_TRX table provides information about every transaction currently executing ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For InnoDB tables, the row count is only a rough estimate used in SQL optimization. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. Choosing the Compressed Page Size The optimal setting of the compressed page size depends on the type and ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...