Search Results
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
From a technical perspective, what are some of the unique supporting infrastructure components that are in a storage engine? Some of the key feature differentiations include: Concurrency: Some applications have more granular lock requirements (such ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
replica_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partitioning (DATABASE) to parallelize transactions. replica_transaction_retries: Number of times replication SQL thread retries transaction in case it ...
https://dev.mysql.com/doc/refman/8.4/en/reserved-accounts.html
This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. One part of the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. For a table describing the available ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The time to acquire the initial locks is not counted as execution time. mysqld writes a statement to the slow query log after it has been executed and after all locks have been released, so log order might differ from execution order. The slow ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy. The validate_password component serves to improve security by ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
NDB Cluster: Concurrent ALTER TABLE statements could cause delays of up to 100 * TransactionDeadlockDetectionTimeout before failing with a lock wait timeout when a client held a conflicting row lock, stalling the accompanying get_commit_count() call. The retry mechanism has been adjusted to identify locking issues ... Note These ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
The goal for your backup strategy is to minimize downtime, using techniques such as hot backup for InnoDB tables and minimizing the duration of the suspend stage where you run customized backup logic while the MySQL server is locked. See Also cold ... These terms are commonly used in information about the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
In this case, any locks held by the original connection still belong to that session, so you may want to kill it by calling mysql_kill(). The MySQL client library can perform an automatic reconnection to the server if it finds that the connection ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-threaded-clients.html
As an alternative to thread programming, applications may find the asynchronous (nonblocking) C API functions useful. To avoid aborting the program when a connection terminates, MySQL blocks SIGPIPE on the first call to mysql_library_init(), ...