Search Results
https://dev.mysql.com/doc/refman/8.4/en/custom-benchmarks.html
Even if the overall performance for your application currently is acceptable, you should at least make a plan for each bottleneck and decide how to solve it if someday you really need the extra performance. In most cases, performance problems turn ... Benchmark your application and database to find out where the bottlenecks ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components.html
MySQL Enterprise Data Masking and De-Identification implements these elements: A table for persistent storage of dictionaries and terms. A component named component_masking that implements masking functionality and exposes it as service interface ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
You can specify a time zone offset when inserting a TIMESTAMP or DATETIME value into a table. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several ...
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a mandatory flag character, optionally preceded by a + or - character, and optionally followed by a comma-separated ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
To install the ddl_rewriter plugin, use the INSTALL PLUGIN statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.so'; To verify plugin installation, examine the Information Schema ...
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
For information available through SHOW statements, it is possible in many cases to obtain equivalent information by using a cursor with an INFORMATION_SCHEMA table. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor ...
https://dev.mysql.com/doc/refman/8.4/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/downgrading.html
Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A replication topology is downgraded by following the rolling downgrade scheme described at Section ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must ...