Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. mysql_migrate_keyring supports the following options, which can be specified on the command line or ... The mysql_migrate_keyring utility migrates keys between one keyring component and ...Note --component-dir, --source-keyring, and ...
https://dev.mysql.com/doc/internals/en/tuning-trace-purging.html
The default for optimizer_trace_offset is -1; the default for optimizer_trace_limit is 1. The SET statement has the following effects: All remembered traces are cleared A later SELECT on the OPTIMIZER_TRACE table returns the first LIMIT traces of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-nodes-groups.html
Note All node groups in an NDB Cluster must have the same number of data nodes. This section discusses the manner in which NDB Cluster divides and duplicates data for storage. It is common for the terms “node” and “data node” to be used ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
An error occurs if a transaction is already active, or if the kernel metadata is locked. Dictionary::getDatafile() Description This method is used to retrieve a Datafile object, given the node ID of the data node where a data file is located and the ...You must use Column class methods for this purpose—see Section 2.3.1, “The Column Class”, for ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, ...This ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, ...This ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host.
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
"rest_of_plan": [ { "database": "test", "table": "alias2", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "records": 1, "cost": 20.2, "chosen": true We choose ref access on the primary key of alias2.
https://dev.mysql.com/doc/workbench/en/wb-admin-server-management.html
The Navigator area also has a Schemas secondary tab for managing databases using your MySQL Connection. The visual tree-based navigation provides detailed information about server and status variables, including the number of threads, bytes sent and ... Manage your MySQL instances with a comprehensive view of your MySQL server ...