https://dev.mysql.com/innodb-buffer-page-lru-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. The ...
https://dev.mysql.com/innodb-buffer-pool-in-core-file.html
Large core files can be problematic for a number of reasons including the time it takes to write them, the amount of disk space they consume, and the challenges associated with transferring large files. Note Access to the data present in buffer pool ... A core file records the status and memory image of a running ...
https://dev.mysql.com/innodb-buffer-pool.html
Note Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. If you see very low youngs/s values when there are no large scans occurring, you might need to ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/innodb-cmpmem-table.html
RELOCATION_OPS The number of times a block of size PAGE_SIZE has been relocated. RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. row *************************** page_size: 1024 buffer_pool_instance: 0 ...
https://dev.mysql.com/innodb-data-encryption.html
Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers. Modifying the keyring_file_data or keyring_encrypted_file_data setting at runtime or ...
https://dev.mysql.com/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect configuration option, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. A deadlock is a situation where different transactions ...
https://dev.mysql.com/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. A lock wait timeout causes InnoDB to roll back only the single statement that was waiting for the lock and encountered the timeout. (To ...
https://dev.mysql.com/innodb-information-schema-metrics-table.html
Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to diagnose specific issues or monitor specific functionality. The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/innodb-init-startup-configuration.html
InnoDB is initialized when the MySQL server is started, and the first initialization of InnoDB normally occurs the first time you start the MySQL server. The first decisions to make about InnoDB configuration involve the configuration of data ...
https://dev.mysql.com/innodb-memcached-replication.html
The c1 column maps to the key, the c2 column to the value, the c3 column to the flag value, the c4 column to the cas value, and the c5 column to the expiration time. The expiration time was set to 0, since it is unused. Because the daemon_memcached ...
