Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
InnoDB is a transaction-safe (ACID compliant) storage engine with commit, rollback, and crash-recovery capabilities to protect user data. The doublewrite buffer adds safety to recovery following an unexpected exit or power outage, and improves ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If you run myisamchk to check tables that mysqld is updating at the same time, you may get a warning that a table is corrupt even when it is not. In this case, if the server tries to update a table that myisamchk is using, the server waits for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
It also holds table rows as they are updated, before the next commit writes them to data memory. MaxNoOfConcurrentOperations limits the number of operations that can be active at any one time in updating transactions. While its value can be ... All ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If the preceding step does not work or does not apply, try to understand whether it would be safe to make the update manually (if needed) and then ignore the next statement from the source. If you are sure that the replica started out perfectly ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
However, mysql_library_init() is not thread-safe in a multithreaded environment, and thus neither is mysql_init(), which calls mysql_library_init(). For each non-SELECT query (for example, INSERT, UPDATE, DELETE), you can find out how many rows were ... Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-14.html
This fix repairs the clean up process for closed connections and also makes the process thread safe. (Bug #28731795, Bug #92625) Updating a result set returned by a server-side prepared statement with SELECT ... (Bug #28101003, Bug #91065) When ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-status.html
However, during an emergency failover process, data consistency is not assured, so for safety, the original primary cluster is marked as invalidated during the failover process. However, during an emergency failover process, data consistency is not ... This section describes the following: InnoDB ClusterSet Status InnoDB ClusterSet Topology MySQL Router Status for InnoDB ClusterSet InnoDB ClusterSet Status AdminAPI's clusterSet.status() command returns a JSON object describing the status of an InnoDB ClusterSet ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html
The following list details the changes to specific options and variables within MySQL 8.0.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Enforce Gtid Consistency Enabled Allows execution of only those statements that can be logged in a transactionally safe manner. Lists the Replication Source configuration metrics and provides a brief description of each. Table 7.28 Replication ...