Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace.html
This section covers topics related to InnoDB tablespaces. ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "parquet", "compression": "auto"}, "file": [{"uri": "oci://mybucket@mynamespace/data_files/data_file_1.parquet"}]}'; Note the following ...CREATE EXTERNAL TABLE table_name (col_name data_type [ENGINE_ATTRIBUTE='Col_Engine_Attribute_JSON'], ...) ENGINE_ATTRIBUTE='Tbl_Engine_Attribute_JSON'; If you are on a version earlier than MySQL 9.4.0, you must use the CREATE TABLE statement to specify ENGINE_ATTRIBUTE ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
In that case you need to add 'innodb_data_file_path=ibdata1:12M:autoextend' to the target server configuration. Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and ...Use, for ... To ...For the various options that you can specify for this operation, see Section 19.3, “Restore ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
Because there are considerable differences in how InnoDB and NDB treat data files, the two storage engines are covered separately in the discussion that follows. An InnoDB tablespace supports only a single data file, whose name must include an .ibd ...One data file is created and added to the tablespace using this ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
In this example, the my_tablespace directory is at the same level as the data directory: mysql> CREATE TABLESPACE `ts1` ADD DATAFILE '../my_tablespace/ts1.ibd' Engine=InnoDB; Note The ENGINE = InnoDB clause must be defined as part of the CREATE ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
Examples: ibdata1:32M;ibdata2:32M:autoextend /abs/path/ibdata1:32M:autoextend innodb-dir/ibdata1:32M:autoextend This parameter, together with backup_innodb_data_home_dir, determines where the InnoDB data files are stored within the backup repository. Any file path specified with this option is taken to be relative to the value of the backup_innodb_data_home_dir option (that is true even if the file path is specified in the form of an absolute path, like ...The backup repository options are ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
If a transaction-safe engine such as InnoDB is being used, a transaction is either completed on the replica or not applied at all, but replication does not guarantee that all data on the source and the replica remains consistent at all times. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
The supported options are: 1: An error does not occur for any missing file, and data loading continues with the existing files. If any of the specified files are not available, an error does not occur and data continues loading for the existing ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
A message sequence either: finishes successfully if it reaches its end-state or is aborted with a Error Message At any time in between local Notices may be sent by the server as part of the message sequence. Common Messages Error Message After the ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...