Search Results
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-11.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Document Store: Connector/NET now supports the NOWAIT and SKIP_LOCKED locking options introduced in the MySQL 8.0 release series (see SELECT Statement). The following changes ...Now the server generates the _id attribute, unless a document already contains ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-environment-category.html
Locked In Memory Enabled Whether mysqld was locked in memory with --memlock. Skip External Locking Enabled This is OFF if mysqld uses external locking, ON if external locking is disabled. Lists the Environment configuration metrics and provides a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
If too many of these occur successively from a given host without a successful connection, the server blocks further connections from that host. Using the new clauses and settings for ROW_FORMAT and KEY_BLOCK_SIZE on CREATE TABLE and ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. After that, the ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_block_ddl Command-Line Format --clone-block-ddl System Variable clone_block_ddl Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Enables an exclusive backup lock on the donor MySQL Server instance during a ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Unlike DELETE, TRUNCATE TABLE cannot be used within a transaction or if you have a lock on the table. See Section 15.1.37, “TRUNCATE TABLE Statement” and Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”. This affects only storage ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-error-handling.html
A transaction deadlock causes InnoDB to roll back the entire transaction. A lock wait timeout causes InnoDB to roll back the current statement (the statement that was waiting for the lock and encountered the timeout). Both deadlocks and lock wait ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-model.html
The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase locking. InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of ...