Search Results
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Truncation operations cannot be performed if the session holds an active table lock. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
Each table is locked and therefore unavailable to other sessions while it is being processed. Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
If two XA transactions committed in parallel on the source are being prepared on the replica in the inverse order, locking dependencies can occur that cannot be safely resolved, and it is possible for replication to fail with deadlock on the replica. XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37357562) Under certain circumstances, a metadata lock can be upgraded or downgraded to a different LOCK_TYPE. (Bug #36234681) InnoDB: When clearing an AHI index from all buffer pool pages, the block state would potentially change to ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #36033684) InnoDB: To improve debugging, the buf_page_t and buf_block_t structure's metadata is now printed to the error log. We fix this by increasing the scope of the lock on the log_status table when querying it to ensure that transactions ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To avoid the unexpected consequence by a race condition, after the replication SQL thread has been stopped, mysqlbackup checks once more if Replica_open_temp_tables is still 0 If it is, mysqlbackup exits the loop and finishes the backup by asserting ... To backup a replica database, add the --replica-info option to your backup ...