Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Change buffer merging may also continue to occur after a transaction is committed, and even after a server shutdown and restart (see Section 17.20.3, “Forcing InnoDB Recovery” for more information). On disk, the change buffer is part of the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. Run the server with change buffering disabled (innodb_change_buffering=0) and do a slow ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
InnoDB Crash Recovery To recover from an unexpected MySQL server exit, the only requirement is to restart the MySQL server. The time it takes to roll back an incomplete transaction can be three or four times the amount of time a transaction is ...To ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Moving Undo Tablespaces Undo tablespaces created with CREATE UNDO TABLESPACE syntax can be moved while the server is offline to any known directory. If default undo tablespaces are moved while the server is offline, the server must be started with ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
For additional information on using CMake to build MySQL, see How to Build MySQL Server with CMake. Perform Postinstallation Setup The remainder of the installation process involves setting up the configuration file, creating the core databases, and ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
If you are going to repair a table from the command line, you must first stop the mysqld server. Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-connecting.html
This section describes the various connection methods for connecting to the deployed MySQL server on the OCI Compute Instance. To find the temporary root password created for the root user, run the following command: sudo grep 'temporary password' ...Connecting with SSH This section gives some detail on connecting from a UNIX-like platform to the OCI ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
The asynchronous connection failover mechanism fails over the connection if another available server on the source list has a higher priority (weight) setting. For a managed group, a source’s weight is assigned depending on whether it is a primary ... This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including Group Replication ...