03 2024 档案
摘要:1. 概述 The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: • Impro
阅读全文
摘要:1. 概述 The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations.
阅读全文
摘要:1 Monitoring InnoDB Table Compression at Runtime Overall application performance, CPU and I/O utilization and the size of disk files are good indicato
阅读全文
摘要:概述 This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also ref
阅读全文
摘要:1. Configuring the Merge Threshold for Index Pages You can configure the MERGE_THRESHOLD value for index pages. If the “page-full” percentage for an i
阅读全文
摘要:1. Configuring Non-Persistent Optimizer Statistics Parameters 开始讲解 非固化的统计数据 This section describes how to configure non-persistent optimizer statistic
阅读全文
摘要:概述 This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. Persistent optimizer statistics are p
阅读全文
摘要:Configuring Spin Lock Polling InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient
阅读全文
摘要:1.Configuring Thread Concurrency for InnoDB InnoDB uses operating system threads to process requests from user transactions. (Transactions may issue m
阅读全文
摘要:1.Saving and Restoring the Buffer Pool State 主要内容为【热启动】,就是把之前常用的内存数据,按照划定的比例快速重新加载到内存中。 To reduce the warmup period after restarting the server, InnoD
阅读全文
摘要:1.Configuring Multiple Buffer Pool Instances 【目的是未来提高并发,减少竞争】 For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into
阅读全文
摘要:1.InnoDB Buffer Pool Size 配置 When increasing or decreasing innodb_buffer_pool_size, the operation is performed in chunks. Chunk size is defined by the
阅读全文
摘要:1.配置文件化 有些InnoDB的配置,是在实例初始化时,就决定了,所以,建议写在configuration file 文件中。 Because MySQL uses data file, log file, and page size settings to initialize InnoDB,
阅读全文
摘要:Deadlocks的定义 A deadlock is a situation where different transactions are unable to proceed because each holds a lock that the other needs. Because both
阅读全文
摘要:1. Phantom Rows的定义(现象) The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different time
阅读全文
摘要:看的什么书啊? --This is the MySQL Reference Manual. It documents MySQL 8.0 through 8.0.34, as well as NDB Cluster releases based on version 8.0 of NDB throu
阅读全文