Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
Thus, you should expect USE INDEX, FORCE INDEX, and IGNORE INDEX to be deprecated in a future release of MySQL, and at some time thereafter to be removed altogether. This provides more fine-grained control over optimizer selection of an execution ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
It was developed according to the specifications of the SQL Access Group and defines a set of function calls, error codes, and data types that can be used to develop database-independent applications. ODBC (Open Database Connectivity) provides a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
It was developed according to the specifications of the SQL Access Group and defines a set of function calls, error codes, and data types that can be used to develop database-independent applications. ODBC (Open Database Connectivity) provides a ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes exist until statement execution ends, at which point the attribute set is ... The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-memory-management.html
Defining an appropriate buffer size limit avoids potential out of memory errors for online DDL operations that create or rebuild secondary indexes. Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
You can check how long your mysqld server has been up by executing mysqladmin version. If mysqld has died and restarted, you may find the reason by looking in the server's error log. On some systems, you can find in the error log a stack trace of ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
As you can see from the result when the SELECT is run a second time, there remains a row in the table matching the WHERE condition, but residing in a different partition (p2). Each name in this list must be the name of an existing partition or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
service-startup-timeout=seconds How long in seconds to wait for confirmation of server startup. If the server does not start within this time, mysql.server exits with an error. You can also stop the server manually by executing mysqladmin shutdown.
https://dev.mysql.com/doc/internals/en/auth-phase-fast-path.html
Assume that client wants to log in as user U and that user account uses authentication method M. The fast authentication path is used if both client and server used method M to generate authentication data in the initial handshake. In that case the ...