Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
The partitioning and (if applicable) subpartitioning used by the partitioned table may be of any type or types supported in MySQL 8.4. Exchanging Partitions Without Row-By-Row Validation To avoid time consuming validation when exchanging a partition ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same types. You can define simple functions that operate on a single ...Information is provided to functions that enables them to check the number, types, and names of the arguments passed to ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
Table 35.5 mysql.perf_schema Metrics Name Source Variable OTEL Type Description accounts_lost Performance_schema_accounts_lost ASYNC COUNTER The number of times a row could not be added to the accounts table because it was full. The following ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Year 1-byte year value in the range 1901-2155 (same as MySQL) Timestamp Unix time (DEPRECATED) Timestamp2 Unix time, with fractional seconds. NDB columns have the same data types as found in MySQL The assignment (=) operator is overloaded for this ... This section provides information about the Column class, which models a column in an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
If the LDAP server does not respond to TCP handshake after a configured amount of time, MySQL abandons the TCP handshake attempt and emits an error message. If the timeout setting is zero, MySQL server ignores this system variable setting. If the ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Note If you are on MySQL 9.1.2 and earlier, you need to update dialect ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
If a connector links to libmysqlclient dynamically, it must be ensured that the newer version of libmysqlclient is installed on the client host and that the connector loads it at runtime. When a client connects to the MySQL server, the server uses ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/8.4/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL server. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...For ...