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 阅读全文
posted @ 2024-03-31 23:54 东山絮柳仔 阅读(42) 评论(0) 推荐(0) 编辑
摘要: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. 阅读全文
posted @ 2024-03-28 23:14 东山絮柳仔 阅读(82) 评论(0) 推荐(0) 编辑
摘要:1 Monitoring InnoDB Table Compression at Runtime Overall application performance, CPU and I/O utilization and the size of disk files are good indicato 阅读全文
posted @ 2024-03-28 00:12 东山絮柳仔 阅读(45) 评论(0) 推荐(0) 编辑
摘要:概述 This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also ref 阅读全文
posted @ 2024-03-27 22:30 东山絮柳仔 阅读(49) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2024-03-27 15:56 东山絮柳仔 阅读(35) 评论(0) 推荐(0) 编辑
摘要:1. Configuring Non-Persistent Optimizer Statistics Parameters 开始讲解 非固化的统计数据 This section describes how to configure non-persistent optimizer statistic 阅读全文
posted @ 2024-03-27 14:42 东山絮柳仔 阅读(25) 评论(0) 推荐(0) 编辑
摘要:概述 This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. Persistent optimizer statistics are p 阅读全文
posted @ 2024-03-27 08:27 东山絮柳仔 阅读(53) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2024-03-26 23:06 东山絮柳仔 阅读(27) 评论(0) 推荐(0) 编辑
摘要:1.Configuring Thread Concurrency for InnoDB InnoDB uses operating system threads to process requests from user transactions. (Transactions may issue m 阅读全文
posted @ 2024-03-24 23:40 东山絮柳仔 阅读(69) 评论(0) 推荐(0) 编辑
摘要:1.Saving and Restoring the Buffer Pool State 主要内容为【热启动】,就是把之前常用的内存数据,按照划定的比例快速重新加载到内存中。 To reduce the warmup period after restarting the server, InnoD 阅读全文
posted @ 2024-03-24 22:00 东山絮柳仔 阅读(31) 评论(0) 推荐(0) 编辑
摘要:1.Configuring Multiple Buffer Pool Instances 【目的是未来提高并发,减少竞争】 For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into 阅读全文
posted @ 2024-03-24 12:30 东山絮柳仔 阅读(35) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2024-03-24 10:19 东山絮柳仔 阅读(52) 评论(0) 推荐(0) 编辑
摘要:1.配置文件化 有些InnoDB的配置,是在实例初始化时,就决定了,所以,建议写在configuration file 文件中。 Because MySQL uses data file, log file, and page size settings to initialize InnoDB, 阅读全文
posted @ 2024-03-23 23:03 东山絮柳仔 阅读(43) 评论(0) 推荐(0) 编辑
摘要:Deadlocks的定义 A deadlock is a situation where different transactions are unable to proceed because each holds a lock that the other needs. Because both 阅读全文
posted @ 2024-03-23 14:15 东山絮柳仔 阅读(32) 评论(0) 推荐(0) 编辑
摘要:1. Phantom Rows的定义(现象) The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different time 阅读全文
posted @ 2024-03-23 10:49 东山絮柳仔 阅读(27) 评论(0) 推荐(0) 编辑
摘要:看的什么书啊? --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 阅读全文
posted @ 2024-03-23 01:05 东山絮柳仔 阅读(40) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示