Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-key-partitioning.html
As of MySQL 9.6.1, you can specify the PARTITION BY KEY option in the CREATE EXTERNAL TABLE statement. Before You Begin Review how to Create an External Table Manually. Once MySQL HeatWave Lakehouse loads a table, you cannot modify the partitioning. mysql> CREATE EXTERNAL TABLE table_1 ( col_1 int, col_2 int, _metadata_filename varchar(1024) ) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_[1-3].csv') PARTITION BY KEY (_metadata_filename); The following example uses a generated column over the metadata ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-main-window.html
Any number of tables may be edited in the MySQL Table Editor at any one time. Adding another table creates a new secondary tab at the top of the editor. By default, the MySQL Table Editor appears docked at the top of the table editor tab, within ...
https://dev.mysql.com/doc/refman/9.7/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...The format of the connection string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Where: scheme: A recognized connection ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. The different ... Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). For more ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndbinfo-select-all.html
ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ndbinfo database Not all ndbinfo tables available in the mysql client can be read by this program (see later in this section). In addition, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-create-select.html
If the destination table does not exist, logging occurs as follows. ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. This includes the case that the destination table exists and IF NOT EXISTS ...SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (If the MySQL Server is running with ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...