Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
For comments on file descriptor limits, see Section 10.4.3.1, “How MySQL Opens and Closes Tables”. This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
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 ...