Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
For example: innodb_data_file_path=ibdata1:10M:autoextend When the autoextend attribute is specified, the data file automatically increases in size by 8MB increments as space is required. Increasing the Size of the System Tablespace The easiest way ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
rapid_compression System Variable rapid_compression Scope Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value AUTO Valid Values ON OFF Whether to enable or disable data compression before loading data into MySQL HeatWave. The ...Most MySQL HeatWave variable settings are managed by OCI and cannot be modified ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
It automatically parses unstructured data formats, which include PDF (including scanned PDF files), PPT, TXT, HTML, and DOC file formats, from Object Storage. As of MySQL 9.1.2, OCR is enabled by default when you ingest files using Auto Parallel ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
If you have external data that you want to use with MySQL HeatWave AutoML, you can load it directly from Object Storage with Lakehouse. MySQL HeatWave AutoML and Lakehouse Overview For MySQL HeatWave on OCI, you have three options to access ...See ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Warning --dump-replica should not be used if the server where the dump is going to be applied uses gtid_mode=ON and SOURCE_AUTO_POSITION=1. --set-gtid-purged=value Command-Line Format --set-gtid-purged=value Type Enumeration Default Value AUTO Valid ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of GTID auto-positioning and automatic failover, and use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and Performance Schema tables to monitor replicated transactions (see Section 29.12.11, ... Before ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The missing transactions can be retrieved from the source using GTID auto-positioning, which automatically compares the source's transactions to the replica's transactions and identifies the missing transactions. GTID auto-positioning means the ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation ...This section describes the privileges required for operations that assign values to system variables at ...
https://dev.mysql.com/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...