Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
An ALTER INSTANCE [ENABLE|DISABLE] INNODB REDO_LOG operation requires an exclusive backup metadata lock, which prevents other ALTER INSTANCE operations from executing concurrently. Other ALTER INSTANCE operations must wait for the lock to be ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The header is used to link together consecutive records, and for row-level locking. The header is used to link together consecutive records, and for row-level locking. With the COMPRESSED row format, the KEY_BLOCK_SIZE option controls how much ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
LOW_PRIORITY affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). HIGH_PRIORITY affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). INSERT [LOW_PRIORITY ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
FLUSH TABLES WITH READ LOCK and the state of the read_only system variable have no effect on log tables. MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
The first thread to obtain a lock on the mutex causes the other threads to wait until the lock is released. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete against each ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
In this case, when the server opens a MyISAM table, it checks whether the table is marked as crashed or whether the open count variable for the table is not 0 and you are running the server with external locking disabled. The following options to ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The most effective means of doing so is to shut down the MySQL server while running myisamchk, or to lock all tables that myisamchk is being used on. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. If the mysqld server was invoked with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
Details can be viewed in the INFORMATION_SCHEMA tables (see Section 17.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”) and Performance Schema data_locks and data_lock_waits tables. The ACID model is a set of database ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-starting.html
LockPagesInMainMemory=1 # On Linux and Solaris systems, setting this parameter locks data node # processes into memory. Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in ...