Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
The optimizer can use spatial indexes defined on columns that are SRID-restricted. For more information, see Section 13.4.1, “Spatial Data Types”, and Section 10.3.3, “SPATIAL Index Optimization”. For InnoDB and MyISAM tables, MySQL can ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Note The function is optimized to work faster for single byte strings (having equal byte length and character length). Note The function is optimized to work faster for single byte strings (having equal byte length and character length).
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables are getting slower and slower you should try to optimize the table with OPTIMIZE TABLE or myisamchk. If you are ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
SQL statement syntax The ANALYZE TABLE, CHECK TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. EXPLAIN SELECT to obtain a description of how tables are processed by the query optimizer. MySQL Server supports some extensions that you are not ...
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 ...