Search Results
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/heatwave/en/mys-hw-lakehouse-limitations-delta.html
MySQL HeatWave Lakehouse has the following limitations for delta lake tables. Support for delta lake tables is restricted to delta tables with features enabled by default by a Spark client. Writing, updating, and creating of delta lake tables in ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of the cluster_operations table, in which operations for other SQL and API ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/internals/en/table-map-event.html
The first event used in Row Based Replication declares how a table that is about to be changed is defined. TABLE_MAP_EVENT: The TABLE_MAP_EVENT defines the structure if the tables that are about to be changed. It is sent as length encoded string ...