Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
mysql> SET @variable = (SELECT model_handle FROM ML_SCHEMA_user1.MODEL_CATALOG ORDER BY build_timestamp DESC LIMIT 1); The following example sets the latest_model variable. mysql> SET @latest_model = (SELECT model_handle FROM ...In the following ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
To avoid frequent compression failures in write-intensive workloads, such as for OLTP applications, MySQL sometimes reserves some empty space (padding) in the page, so that the modification log fills up sooner and the page is recompressed while ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for failover. This method is simple ...Each identifier uniquely identifies a set of binary log events that together make up a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
*.ibz Compressed form of InnoDB data files from the MySQL data directory. The backup_history and backup_progress tables created by mysqlbackup use the CSV format, so the backup always includes some files with this extension. The backup_history and ... The following table shows the different types of files that are included in a single-file backup image or a directory ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_INDEXES WHERE index_id=457; +----------+------+----------+-------+ | index_id | name | table_id | space | +----------+------+----------+-------+ | 457 | idx | 327 | 283 | ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
When creating an incremental backup, you have to indicate to mysqlbackup the point in time of the previous full or incremental backup. If the --start-lsn option is used, a full scan is performed even if --incremental=optimistic is specified since, ...To restore data up to, for example, time t, you simply restore first the full backup, and then, on top of it, the differential backup taken for time ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
The delay is intended to provide enough time for the file system on the recipient host to free space before data is cloned from the donor MySQL Server instance. They can be changed dynamically at runtime using the SET statement, which enables you to ... This section describes the system variables that control operation of the clone ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
When the MySQL server halts or restarts, the data in MEMORY tables is lost. The tables themselves continue to exist because their definitions are stored in the MySQL data dictionary, but they are empty when the server restarts. However, the two ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Because MySQL does not check if a function really is deterministic at creation time, the invocation of a stored function with the DETERMINISTIC keyword might carry out an action that is unsafe for statement-based logging, or invoke a function or ...