Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
An instance of NdbBlob is created using the NdbOperation::getBlobHandle() method during the operation preparation phase. getLength() Gets the length of a blob, in bytes getNdbError() Gets an error (an NdbError object) getNdbOperation() Get a pointer ... This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
This example creates the Object Storage folder data_files and uploads the files data_file_1.csv, data_file_2.csv, and data_file_3.csv. Create a session variable with the characteristics of the input_list to create the external table and specify the ... Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. Table files are exported from the export server into the /tmp/export directory and this directory is secure (not ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. PARTITION BY KEY are similar to those for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. If in_table is NULL and no snapshot exists, a new snapshot is ...The views are calculated based on the overall and/or delta ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
Change to the standard mouse pointer tool and pick up any objects you would like to place on the newly created layer. For more information about text objects, see Section 9.1.9, “Creating Text Objects”. 9.1.2.2.7 The Table Tool Use this tool to ... The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...