Search Results
https://dev.mysql.com/doc/refman/9.7/en/command-line-options.html
Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...
https://dev.mysql.com/doc/refman/9.7/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-using-uri-or-key-value-pairs.html
This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. For information on establishing connections using command-line options, for ...For additional information if you are unable to connect, see Section 8.2.22, “Troubleshooting Problems Connecting to ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component-installation.html
The Connection Control Component is available in both the Community and Enterprise distributions of MySQL. While it can be used with the default settings, you may wish to tune its operations to meet conditions specific to your environment. The next ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/data-masking-components.html
MySQL Enterprise Data Masking 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 for developers.
https://dev.mysql.com/doc/refman/9.7/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 ...