Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert.html
In MySQL 8.4, the DELAYED keyword is accepted but ignored by the server. If both the column list and the VALUES list are empty, INSERT creates a row with each column set to its default value: INSERT INTO tbl_name () VALUES(); If strict mode is not ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-information-schema-tables.html
But it does not hold mutexes on all thread groups at the same time, to prevent a statement against TP_THREAD_STATE from blocking the entire MySQL server. Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.source.html
The number of remaining binary log files varies depending on the length of the timespan between the last backup and the time to which you want to bring the database up to date. The longer the timespan, the more remaining binary log files there may ... To fix a corruption problem in a replication source database, you can restore the backup, taking care not to propagate unnecessary SQL operations to the replica servers: Shut down the source database and then use, for example, the copy-back-and-apply-log command, to restore a backup of it and prepare the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. With the removal of .frm files in MySQL 8.0, this column ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Thus, if a table is touched for the first time, it implicitly starts a ...
https://dev.mysql.com/doc/x-devapi-userguide/en/synchronous-vs-asynchronous-execution.html
Any MySQL client that supports the X Protocol can provide asynchronous execution, either using callbacks, Promises, or by explicitly waiting on a specific result at the moment in time when it is actually needed. Traditionally, many MySQL drivers ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/memory-usage-advisors-ref.html
Default frequency 00:05:00 Default auto-close enabled no Query Cache Has Sub-Optimal Hit Rate Note This advisor does not evaluate against MySQL 8, or higher. Default frequency 00:05:00 Default auto-close enabled no Query Cache Potentially Undersized ...It is true that logical I/O is not free, and that the DBA should work to keep all I/O to a minimum, but it is best if most data access is performed in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prepare.html
Prepare Data To prepare the data for topic modeling: Connect to your MySQL HeatWave Database System. mysql> CREATE DATABASE topic_modeling_data; mysql> USE topic_modeling_data; Create the table to use for both training and testing. mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source distribution. A bulk ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
If all members are not running the same MySQL Server version, you can specify a new primary member that is running the lowest MySQL Server version in the group only. You can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that ... This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the ...