Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption when backing up InnoDB data files; mysqldump provides online logical backup. They are not optimal ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
In this situation, there is no I/O penalty related to COMMIT or ROLLBACK, and InnoDB can automatically optimize the read-only workload. You might change the column and index definitions slightly, for better space utilization, reduced I/O and memory ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
The optimizer can transform a correlated scalar subquery to a derived table when the subquery_to_derived flag of the optimizer_switch variable is enabled. This reflects the cardinality check that the optimizer performs as part of evaluating the JOIN ... A correlated subquery is a subquery that contains a reference to a table that also appears in the outer ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
Declaring a nondeterministic routine as DETERMINISTIC might lead to unexpected results by causing the optimizer to make incorrect execution plan choices. Declaring a deterministic routine as NONDETERMINISTIC might diminish performance by causing ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
If a generated column is indexed, the optimizer recognizes query expressions that match the column definition and uses indexes from the column as appropriate during query execution, even if a query does not refer to the column directly by name. For ...Values of a generated column are computed from an expression included in the column ...
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 ...