Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
These and later versions of the MySQL Server and NDB Cluster use the new temporal types by default, can read and write data using the old temporal types, but cannot create tables that use the old types. This section provides information about the ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
We have created a very simple benchmark to check the performance of each of these. 1.4.2.3.2 Single-row operations After the operation is created using NdbTransaction::getNdbOperation() or NdbTransaction::getNdbIndexOperation(), it is defined in the ... An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-tableactivity-category.html
Table 6.44 Table Activity Metrics NameDescriptionCreated Tmp Disk Tables (Delta) The total number of temporary tables that were converted to disk based tables, due to exceeding either tmp_table_size or max_heap_table_size. Created Tmp Files (Delta) ... Lists the Table Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
rapid_auto_vector_index_enabled System Variable rapid_auto_vector_index_enabled Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value ON Valid Values ON OFF As of MySQL 9.5.0, controls automatic vector index creation for ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-increase-dbsystem-storage.html
It is recommended that you create a backup of the DB System before updating the data storage size. Increasing Storage by Backup and Restore Create a backup of the DB System. Create a new DB System from the backup, and define a larger storage in the ... Increasing DB System Storage 3.4.7 Increasing DB System Storage You can increase the DB System storage by updating the data storage size of a DB System, by backup and restore, or by export and ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...For ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but ...For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration files, one per node ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. 19.1.2.5.1 Creating a Data Snapshot Using mysqldump To create a snapshot of ... If the source database contains existing data it is necessary to copy this data to each ...