Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The BINARY and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.4, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. utf8mb3 remains supported for the ...For more information, see Section 12.9.2, “The utf8mb3 Character Set (3-Byte UTF-8 Unicode ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
The clone plugin permits cloning data locally or from a remote MySQL server instance. The cloned data comprises a fully functional data directory, which permits using the clone plugin for MySQL server provisioning. Figure 7.1 Local Cloning ...
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ... Components must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. For information about such tables, see Section 10.4.4, “Internal Temporary Table Use in MySQL”. For information ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. Do not ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
(This flag is on by default on Linux.) Using NFS with MySQL You should be cautious when considering whether to use NFS with MySQL. Potential issues, which vary by operating system and NFS version, include the following: MySQL data and log files ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
MySQL Events are tasks that run according to a schedule. While there is no provision in the SQL Standard for event scheduling, there are precedents in other database systems, and you may notice some similarities between these implementations and ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from source, invoke CMake with the -DWITH_EXAMPLE_STORAGE_ENGINE option. To examine the source for the EXAMPLE engine, look in the storage/example directory of a MySQL source ...