Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
(Transactions may issue many requests to InnoDB before they commit or roll back.) On modern operating systems and servers with multi-core processors, where context switching is efficient, most workloads run well without any limit on the number of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-threadactivity-category.html
Lists the InnoDB Thread Activity metrics and provides a brief description of each. Table 6.17 InnoDB Thread Activity Metrics NameDescriptionMain Thd Log Flush Writes (Delta) The number of times InnoDB redo logs are written and synced to disk by the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...It also discusses the use of autocommit, consistent non-locking reads, and locking ...
https://dev.mysql.com/doc/internals/en/innodb-record-structure.html
This page contains: A high-altitude "summary" picture of the parts of a MySQL/InnoDB record structure. After reading this page, you will know how MySQL/InnoDB stores a physical record.
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the ...For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup-recovery.html
This section covers topics related to InnoDB backup and recovery. For information about backup techniques applicable to InnoDB, see Section 17.18.1, “InnoDB Backup”. For information about point-in-time recovery, recovery from disk failure or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-model.html
The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase locking. InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-architecture.html
The following diagram shows in-memory and on-disk structures that comprise the InnoDB storage engine architecture. For information about each structure, see Section 17.5, “InnoDB In-Memory Structures”, and Section 17.6, “InnoDB On-Disk ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuration.html
This section provides configuration information and procedures for InnoDB initialization, startup, and various components and features of the InnoDB storage engine. For information about optimizing database operations for InnoDB tables, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-tables.html
INFORMATION_SCHEMA InnoDB tables can be used to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to troubleshoot performance and capacity issues. As your database becomes bigger and busier, running up ...For ...