Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-innodb-cluster.html
When used with a MySQL InnoDB Cluster, MySQL Router acts as a proxy to hide the multiple MySQL instances on your network and map the data requests to one of the cluster instances. Introduction For client applications to handle failover, they need to ... MySQL Router is part of InnoDB Cluster and is lightweight middleware that provides transparent routing between your application and back-end MySQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-innodb-buffer-pool.html
If no data is returned within 2 minutes, the report times out and an error is displayed. The InnoDB Buffer Pool Usage Report displays the amount of space used in the InnoDB buffer pool and how the space is used. Each block in the grid represents a ...This page displays a warning about the table and resource requirements of the report generation process and prompts you to select a MySQL Server to run the report ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...InnoDB uses the information in the rollback segment to perform the undo operations needed in a transaction ...It keeps ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
You can determine the default storage engine on a MySQL Server instance by issuing the following statement: mysql> SELECT @@default_storage_engine; +--------------------------+ | @@default_storage_engine | +--------------------------+ | InnoDB | ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. MySQL replication is based on the binary log where MySQL writes SQL statements that modify data. Cascading actions for InnoDB tables on ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/internals/en/innodb-page-structure.html
This discussion deals only with the most common format, for the leaf page of a data file. InnoDB stores all records inside a fixed-size unit which is commonly called a "page" (though InnoDB sometimes calls it a "block" instead). I'll start this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value ...The number of indexed columns in a table The number of ...For more information, see Section 17.8.10.1, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-workloads.html
A number of major differences in behavior between the NDB and InnoDB storage engines with regard to some common types of database-driven application workloads are shown in the following table:: Table 25.2 Differences between InnoDB and NDB storage ... NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
If frequent deadlocks highlight a problem with transaction structure or application error handling, enable innodb_print_all_deadlocks to print information about all deadlocks to the mysqld error log. When deadlock detection is enabled (the default) ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...